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.
Any ideas?
Paul
Hello,
I suppose you’ve already done the following, but see the following link or similar
https://docs.microsoft.com/en-us/office/troubleshoot/excel/issue-when-save-excel-workbooks
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
_select go
_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
I deleted unused add-ins and retained only one. Since it's sporadic, I'll see if this issue reappears again and let you know. Thanks for your help!
Paul
Since deleting the unused add-ins, I have encountered no problems saving the file. Your help is much appreciated.
