Spreadsheet Add-in User's Guide for Excel

Disconnecting from Essbase

When you finish using drill-through, disconnect from the Essbase server to free up a port on the server for other Essbase Spreadsheet Add-in users.

To disconnect from the server:

1. Select Essbase > Disconnect.

   Essbase displays the Essbase Disconnect dialog box, where you can disconnect any spreadsheet that is connected to a database.

   Figure 205. Essbase Disconnect Dialog Box
   
   
   

   Note:

   Essbase may return an error message when you attempt to disconnect after using drill-through. If an error message is returned, select Essbase > Retrieve from the sheet and then disconnect.

2. Select a sheet name from the list and click Disconnect.
3. Repeat Step 2 until you have disconnected from all active sheets.
4. Click Close to close the Essbase Disconnect dialog box.

   Note:

   You can also disconnect from the server by closing Excel. An abnormal termination of ana Excel session, such as a power loss or system failure, does not disconnect your server connection.