Users may encounter a problem where Microsoft Excel crashes when attempting to open specific files, accompanied by an error message stating "Automation Error: The object invoked has disconnected from its clients."
This article contains the following topics:
- This issue has been reported specifically in relation to reports built in Excel, usually when those reports have existed for some time, have been shared using shared drive applications, such as Share Point or Dropbox, or that use external links and data connections.
- The problem manifests when attempting to open files containing links to the original tabs. The crash typically occurs immediately after opening, sometimes with the mentioned error message, but often without any specific error notification. While the problem is not consistently reproducible, it can disrupt the normal workflow.
- Open MS Excel (Any File or a new file; avoid opening the problematic files at this stage).
- Pull up Task Manager (right click the Windows toolbar at the bottom to access Task Manager).
- Locate MS Office or Excel Icon in Background Processes, right-click, and select properties.
- Under Compatibility, click "Run Compatibility Troubleshooter."
- After running the troubleshooter, test the problematic file. If it works correctly, click "Apply settings to this program." If the issue persists, proceed to the next step.
- Choose from the options provided by the troubleshooter (e.g., indicating that it worked in a previous version of Windows, such as Windows 7).
- Test the file again. If it works, click "Apply settings to this program." If not, continue with the troubleshooting steps as needed.
This resolution suggests that the files or their contents may have been originally created under conditions associated with an older version of Windows. The error implies a compatibility issue between the Excel file and the current version of Windows. Although the exact cause may not be fully understood, this step-by-step process provides a temporary workaround to address the compatibility concerns.
To address the issue more comprehensively and prevent future occurrences, it is recommended to follow these steps:
- Rebuild the files by downloading a new cube from Catalyst.
- Only copy over the tabs that are essential, choosing "overwrite" when prompted.
- This ensures that the files are created with compatibility for the current Windows version, minimizing the risk of encountering the reported issue.
By following these steps, users can resolve the immediate problem and implement a long-term solution to prevent the recurrence of Excel crashes associated with this error.