Error Messages/42645

Example error messages

 The object invoked has disconnected from its clients.

 The RPC server is unavailable.

Cause

This error indicates a problem occurred while a Spreadsheet function in Analytica was attempting to communicate with an Excel process in order to read or write data from/to the spreadsheet. The actual text of the error message is produced by Excel, and thus a wide variety of messages are possible.

Variations

The object invoked has disconnected from its clients

This occurs in Excel 2010 when the user has closed the spreadsheet from the Excel interface after SpreadsheetOpen has obtain a handle to the workbook object, but kept Excel running.

Side note: This seems to be due to a bug in Excel 2010. The premise of the Excel API that applications like Analytica use to communicate with it states that Excel should keep track of how many clients are using a particular workbook, and should close that workbook only after the last client has stopped using it. However, Excel 2010 seems to ignore this contract when the workbook is closed through the Excel GUI -- closing all connections that may have previous existed with applications such as Analytica.

To recover, dirty the definition of the variable containing SpreadsheetOpen, forcing it to re-evaluate SpreadsheetOpen and thus re-establish in the process.

The RPC server is unavailable

In Excel 2010, this will happen if the spreadsheet is loaded into the visible user interface of Excel, and then after SpreadsheetOpen has evaluated and established a connection to the spreadsheet, you close Excel 2010 entirely.

This error will also occur in all variants of Excel (2003, 2007 and 2010) when you kill the Excel.exe process from the task manager (or if it crashes on its own) after SpreadsheetOpen has established a connection.

In either case, the error occurs when another Analytica spreadsheet function attempts to use the workbook connection that had been previous opened by SpreadsheetOpen.

To recover, dirty the definition of the variable containing SpreadsheetOpen, forcing it to re-evaluate SpreadsheetOpen and thus re-establish in the process.

Other errors

Invalid Index One example of where this will happen is if you attempt to use Spreadsheetsetinfo(wb, 'Activesheet', 'sheet#'), where sheet# is not present in the workbook.

If you encounter other errors, please list them here and provide any information you can about why they may have occurred.