Excel prompts to save every time I close a file

Question

Excel prompts to save every time I close a file

Anonymous

Excel prompts me to save every time I close a file, even if I just saved and it shows as Saved to this PC in the header and Saved in VBA. Also, every time I close Excel, it prompts me to save my personal.xls even though no changes have been made to it. These prompts happen even with a blank workbook that has no formulas, no macros, nothing. Save it and close and it will prompt to save again. This started happening 3 or 4 months ago. Office 365, Windows 11. I think it started after updating to Windows 11. I tried adding macros to Auto_Close and CloseBook to force the status to Saved = True and to suppress prompts at close, but I still get the prompts every time I close a workbook and Excel. Super annoying.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Answer 1

I have absolultely the same problem since 2-3 months.

Started immediately after Office 365 update - I am sure about it as it tells me "please close outlook one note excel word" to apply updates.

And within 1 -2 hours of the update I noticed this annoying change of behavior on absolutely all files - including empty / new ones.

Or files which I use since years, and know perfectly well have no "today()" or similar command inside them, so they never prompt me to save them if I have not modified them.

This is a problem, and a total time waster - because sometimes I want to not save (experimental changes) I've made - and not this fake prompt makes me start thinking each time I close a file - have I made changes really, do I want to save them.

Leading to either lost data, or save something wrong in the file (e.g. pressed some button by mistake, and overwrote the contents of some cell).

Or just wasting my time to start CTRL-Z ing to see the latest changes, and do I want to save them.

Answer 2

Would love to know the resolution to this as I continue to have this same issue which just started recently. I have autosave turned off but every time I save a file and then go to close it, I am prompted to save it again. I've started saying "don't save" and hope the info was saved the first time. Or I just close the file before saving and hope I am prompted to save at that time. If I just saved, and have not changed a thing, have not even moved a cell, why am i being prompted to save again upon closing.

Answer 3

Dear KPurdy,

Good day! I hope you are doing well.

After further investigation on our end, we have determined that this issue requires a deeper analysis and more details from your side. I have initiated a Private Message so you can send more information while ensuring that your personal information remains secure. You can view your private messages by going to the Question Info section and clicking the Private Message icon shown below.

Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Ralph Chawatama | Microsoft Community Moderator

Answer 4

Anonymous

Autosave can be clicked on or off and it still prompts me to save when I close the workbook.

0 comments

Answer 5

Anonymous

O365 updates internally and not via win update

If you open a new doc you have to "SaveAs" to name that doc, if you subsequently reopen that doc to edit, then autosave on the ribbon would be on

0 comments

Share via

Excel prompts to save every time I close a file

9 answers