July 7, 2016
I have a large file that normally works well, but sometimes I cannot save it. It's a random event. I can open the file and work in it as normal, but not save it, not even Save As to another name or location. A dialog box appears when this occurs, Document Not Saved. I have two computers, and it makes no difference which one I use; same issue. However, when I send the file to a colleague, he can open and save the file to a new name and send it back to me, and it works fine for a while--and then the File Save operation doesn't work once again, at unpredictable times.
I am thinking that there might be a local setting I'm using that my colleague is not using and that this setting is interfering with the Save operation. I did notice that the file recalculates upon saving, although I don't need it to do this because it's on automatic calculation anyway. Or maybe it has something to do with Trusted Locations or something.
February 20, 2020
I suppose you’ve already done the following, but see the following link or similar
many of the conflicts are because of add-ins
Try to delete excel add-ins (corrupted Excel add-ins might cause errors when you try to save your file)
Here’s how you can disable these add-ins on your system:
_Open Microsoft excel options
_click on the file
_Open manage, click on add-ins
_Disable the add-ins and see if the problem is resolved
it’s not easy to answer, but if everything works on your colleague’s PC, it’s already a start to delete errors
July 7, 2016