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

Asha Kanta Sharma 81

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...

Emily Hua-MSFT 27,526 Reputation points

2020-07-30T09:25:29.553+00:00

I am checking the status of this issue. Do you have any update for it?
Emily Hua-MSFT 27,526 Reputation points

2020-08-05T05:06:18.957+00:00

Is there any update? Please remember to share us with solution when you solve this issue, and accept you reply as an answer.
Isahamster11 1 Reputation point

2021-12-17T19:16:43.57+00:00

Yeah, this error caused me half day of work. i've tried the effort of copying it onto a plain new excel worksheet, but it just keeps spinning and does not let me save or even do anything in the new worksheet. I was able to save it as pdf, since it is something I work on top of other people's worksheet, I will be relying on the next worksheet I receive would not have the same issue.

Hope this helps a little?

Best of luck!
Kyle Strachan 0 Reputation points

2023-06-23T17:49:58.1666667+00:00

Hello,

I received this error when the date format of my PC was changed from YYYY-MM-DD to MM-DD-YYYY. My document also uses custom formatting. A date format change also appears to trigger this.

Kyle
Phanishwar Kumar 50 Reputation points

2023-07-17T05:56:52.5666667+00:00
Solved:

Copy the file to another system.

Open the file

Save the file

Copy the saved file back to your system and replace the existing file.

The file should work normally now.
Keshav Modugu 0 Reputation points

2023-07-21T11:27:15.6666667+00:00

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
Runit Sareen 0 Reputation points

2023-08-08T07:22:48.27+00:00

@Phanishwar Kumar Thanks!!
Sarah Henry 5 Reputation points

2023-09-08T18:53:23.72+00:00

I had an entire linked workbook with several tabs and embedded objects that I'd worked on for an entire day, and this happened. I'm not savvy enough to understand the other solution that helped everyone, but from reading this forum, I got the idea to Select all Tabs, "Move or Copy", I selected the "Copy" box, and selected the new blank workbook I had opened, to "copy" them to, and hit ok. To my delight, it worked, and I was able to save the new workbook.
Andres Anano 0 Reputation points

2024-01-11T08:43:26.4666667+00:00

Phanishwar Kumar thank you; it worked for me
Darren McMartin 0 Reputation points

2024-02-03T01:18:44.1733333+00:00

This problem is still occurring in Excel. It has existed for over 3 years and Microsoft still haven't fixed it. It's ridiculous.
Vernon L. Kury 0 Reputation points

2024-02-18T16:27:05.4533333+00:00

The correction posted by FEDERICO GALLERANI seemed to work great. Pity this is a apparent problem caused by serveral things (none of which, as far as I can tell, are affrimed by the Excel team at Mocrosoft) that should be more easily avoided. Glad I did not lose more time than was needed to fix this issue.
melsey 0 Reputation points

2024-02-29T20:02:35.0566667+00:00

Thought I would share my experience with this horrendous Excel error. I too lost a lot of work to the error. I've started doing a SAVE AS every once in a while so I build up a number of old backup files. All my versions will be working, then I usually encounter this error when I do another copy. I then try to open the previous save as version, and I find that file does the same thing! Even though it was working 100% perfectly minutes or days ago. I usually have to go back 2 or 3 older copies to get one that works. How can a file work one day perfectly, and I don't touch it, and then all of a sudden it has the same save bug? Now, in addition to doing a save as, I copy all the VBA code/modules/classes/etc to text files as a backup. As sometimes when I get the error, all my modules will be inaccessible so I can't copy the text out of them into another file, once the error occurs.
Boily, Romain (RTA) 0 Reputation points

2024-03-12T12:10:42.3766667+00:00

You saved my life ! Thanks so much !
Davis Holt 0 Reputation points

2024-03-19T20:39:58.3333333+00:00

such an annoying error, and microsoft doesn't seem to care
Jamie Meechan 0 Reputation points

2024-04-08T02:05:29.58+00:00

Easy fix I found - remove all custom number formatting. Once saved successfully you can add it back.
James T 0 Reputation points

2024-04-11T13:40:00.06+00:00

Still having this issue here in May of 2024. Regular spreadsheet, no VB, nothing fancy beyond some arithmetic formulas. These files are stored on a network drive and opened on a computer on that network, but why in the world would there a be a problem with that?? I think that's a pretty common business set up...

I copy and paste the file onto my desktop using a new window, open that one and I can save it, but I lose all of my work since the last time I saved it. Been an issue for years I see and no fix? What?

22 answers

Amauri 0 Reputation points

2024-02-29T20:12:41.2433333+00:00

I ran into the same issue and I didn't have a macro in my spreadsheet and it was pretty simple one, so I just copied and pasted into a new workbook. Another wonderful Microsoft product.. sigh.. anything they touch they manage to screw up
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Abi 0 Reputation points

2024-04-12T11:09:58.4+00:00

I have resolved mine by Going to File > Info > Inspect Workbook then I've just remove what seems odd to me like Link to other files , Invisible objects , hidden names, xml. Viola!
Please sign in to rate this answer.

0 comments No comments
Sign in to comment