Annoying “Do you want to save..” Dialog Box

Topic

New Reply

Just open an Excel .xlsx file and take a look. When closing it, Excel constantly asks:
“Do you want to save the changes you made to “abc.xlsx?”
In fact, no change has been made.
How to disable this annoying dialog box?
Thanks.
Armstrong

Reply | Quote

Replies

Do you have any formulas in your book? If you have a formula such as =Now(), this will cause a change to your book and force the Save Changes dialog.

Reply | Quote

Oh, I didn’t know that. Thanks.
Armstrong

Reply | Quote