asked on
Unable to save Excel document because of errors
Hello.
I have this problem.
When user tries to save an Excel file, Excel shows an error message:
"Errors where detected while saving April.xlsx. 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."
Then the user click Continue button and try to save it again but the repair obviously failed because a new error message appears - that there are too many formula errors.
I tried to copy data to the new Excel document as many sites recommended but it didn't help.
Note: This Excel file was copied and rewritten many many times.
Thank you for any advice.
I have this problem.
When user tries to save an Excel file, Excel shows an error message:
"Errors where detected while saving April.xlsx. 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."
Then the user click Continue button and try to save it again but the repair obviously failed because a new error message appears - that there are too many formula errors.
I tried to copy data to the new Excel document as many sites recommended but it didn't help.
Note: This Excel file was copied and rewritten many many times.
Thank you for any advice.
Microsoft Excel
Last Comment
Mike in IT
ASKER
Well, I am from IT Dept and someone from Financial Dept had this problem so there is no way I could tell you more about used formulas.
Even people from FD wouldn't be able to tell you where the problem is because this Excel file was created a years ago. They copied the file and made a little edit and saved it. The next week or month they did it again with the latest version of the file. So over the years there are so many formulas they even do not know about. So it's pretty hard to say something specific. And they own many files like this one.
Today Mrs. XYZ did this thing: She took a spreadsheet from one Excel and put them into another Excel. The error appeared after that. I told her to put all spreadsheets into a new Excel but it didn't help.
There is an interesting thing. This error is rare. We usually figure the problem out by creating a new Excel or something like this. But today...
I hope it helped a little.
Even people from FD wouldn't be able to tell you where the problem is because this Excel file was created a years ago. They copied the file and made a little edit and saved it. The next week or month they did it again with the latest version of the file. So over the years there are so many formulas they even do not know about. So it's pretty hard to say something specific. And they own many files like this one.
Today Mrs. XYZ did this thing: She took a spreadsheet from one Excel and put them into another Excel. The error appeared after that. I told her to put all spreadsheets into a new Excel but it didn't help.
There is an interesting thing. This error is rare. We usually figure the problem out by creating a new Excel or something like this. But today...
I hope it helped a little.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you. I will check it tomorrow.
ASKER
solved? maybe
Let us know if you are able to fully solve this. if not we will continue to help as much as possible.
It does seem odd that copying the data from this erroring file doesn't help. Are you able to review the formulas to see if there are errors or circular references? does the file do what it is supposed to currently?