Consider the following scenario: You are working on a project to automate Microsoft Office. Therefore, you have opened the Microsoft Visual Basic for Applications editor. An Excel worksheet is open as well, which contains a think-cell Excel data link.
You delete the Excel worksheet where think-cell's Excel data link resides. Excel may show an error message: "Object required".
If you try to save the Excel file, Excel shows an error message:
"Errors where detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."
When you click Continue, the repair fails.
If, instead of trying to save the file, you try to insert a new Excel worksheet, Excel crashes.
The problem is caused by a bug in Excel. We have filed a case with Microsoft. If your company has a Microsoft Office Support contract and you want to contact Microsoft to ask for a fix, you may refer to Microsoft case number 114072911657591. The error can be reproduced without think-cell.
Please perform the following steps:
When you encounter this error, you can save your data in a new Excel document or discard the changes and repair the original document:
To save changes you made to your document, copy the worksheets you changed to a new Excel document and save it.
You can repair your Excel document by deleting any Visual Basic for Applications (VBA) projects from your document. However, simply deleting them in the Visual Basic editor is not sufficient. Please use the following procedure:
You should now be able to delete the worksheet with think-cell links and then save the document.