When you finish retrieving and navigating through data, disconnect from the server to decrease user count and to enable other Spreadsheet Add-in users access to that port.
To disconnect from the server:
Select Essbase, and then Disconnect.
The Essbase Disconnect dialog box is displayed; from which you can disconnect worksheets that are connected to a database.
From the list, select a worksheet name, and then click Disconnect.
Repeat step 2 until you disconnect all active sheets.