Ask for saving xlsm file

Ian3 66

When closing an xlsm file, it always asks to save even it is not changed. Is there a way to disable it? Thanks. Ian

Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor

2020-08-03T07:15:52.4+00:00
Did this problem only appear in a specific .xlsm file or all .xlsm files? Asking for saving behavior may occurs by these common scenarios:

There is a volatile function used in the file. Examples of volatile formulas are listed in the more information section of this article.

The file has been opened in a newer version and formulas have been calculated. See article in the more information section.

A formula that contains a link to a formula in another workbook and that uses volatile functions.

Linked pictures.

Iterative formulas.

Charts that are on chart sheets or that are embedded into worksheets but that have their source data in another workbook.

VBA code that updates the workbook.
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor

2020-08-11T01:16:20.023+00:00

I am just writing to see if you have obtained the opportunity to test the solution. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.

Accepted answer

1 additional answer