Microsoft should FIX - "Errors were detected while saving (filename)"

Question

Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019.

"Errors were detected while saving (filename). 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."

THIS ERROR/BUG HAS RUINED MY LIFE PROFESSIAONLLY.

FIX IT WITHOUT FURTHER DELAY...

Answer 1

Hi AshaKantaXharma,

This is also happening in Office 365 (O365 is work assignment but typing this on my home pc). There is no VBA code in the workbook: in fact I have never seen the message before yesterday (10/8/21) and have written many VBA scripts over the years (beginner to (I think) intermediate).

It occurred for me when I used CUBE formula to create an income statement that was linked to a data model in the workbook using CUBE formula. At a certain point when I went to close down for the evening I wanted to save my progress so I could continue today. My progress was lost.

The scenario: In a new workbook -

• A data model was added with three queries.
• Two pivot tables were created. Same data one more detailed than the other (IE summary and next level down).
• The summary pivot table was converted to formula using the OLAP Tools>Convert to Formulas menu option. Those formula were moved around to create the income statement.
• These were checked against the second unconnected pivot table (but note they were not connected).

At the point of saving the file the values required for the associated categories were correct.

As I understand it the data model does not reside in the excel workbook but is somehow connected to it. Perhaps there is a disconnect there (can't speak for the VBA element). However, so far, the same disconnect does not apply for workbooks with data models without CUBE formulae.

This is my first ever posting on a Microsoft forum and wanted to add my support to your cause. This needs fixing. I will look into how I can raise this as a bug with Microsoft directly or add my support more effectively. I will also push the organisation I am on assignment with to push this to Microsoft. They are a huge organisation in the UK who will sort out the mental health issues I will have trying to resolve this issue ;-)

Best Regards
Mike

Answer 2

Can confirm as per darthpixel-3486, my error consistently came when deleting a custom format, specifically
;;;

Changing the format of the cells, compared to deleting the format, didn't result in the corruption/error

Answer 3

I checked the above and my language settings seemed to be consistent. So instead I resorted to copy/move of the sheets in the workbook one by one and changed the links internally to the new workbook. I also copied the macro code to plain text in Word and pasted them to the new workbook. No idea if the error will happen again but at least for now its functioning correctly.

Answer 4

Hi,

To fix this error, you can try these steps-

1. Save a copy of the file with a different name or in a different location. Sometimes, the error occurs due to file corruption, and saving a copy can help fix the issue.
2. Ensure you have the latest updates installed for Excel and your operating system. Updates often include bug fixes that can address known issues.
3. If you're using add-ins or macros, try disabling them temporarily and see if you can save the file without the error. This can help identify if any specific add-in or macro is causing the problem.

If these methods do not work out for you, try using the methods mentioned in this article to fix the "Errors were detected while saving Excel"

Best Regards.

Answer 5

Hi Take empty work book and do the format painter with existing file (error file) and take copy the data and paste in new work book and save it