• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem when saving an Excel file

UranusJasari

UranusJasari

New Member
When saving an Excel file, a message "Errors were detected while saving ..." or "Document not saved" pops up and the document is not saved
What can be wrong?
 
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 so that this problem does not happen again if you delete any Visual Basic for Applications (VBA) projects. Simply deleting them in the Visual Basic editor is not sufficient. Please use the following procedure:

Make a backup of your document file.

Download and run the Excel Fix Toolbox

Open your document in it.

In the tree view of your document, select _VBA_PROJECT_CUR and press Del to delete it.

Confirm deletion and close the Excel Fix Toolbox

Open the document in Excel.

There will be a dialog box Microsoft Visual Basic → File not found. Hit OK.

There will be another dialog box Repairs, with Lost Visual Basic project listed. Hit Close.

Save your document.

You should now be able to delete the worksheet with think-cell links and then save the document.

https://www.fixtoolbox.com/excelfix.html
 
You must log in or register to reply here.
Back
Top