Blogs

Tip of the Week - Excel always prompts me to SAVE! But I didn't DO anything!

By ILTA Tips posted 07-24-2017 09:49

  

Excel always prompts me to SAVE! But I didn’t DO anything!

File > Options > Advanced, under General make sure that Ignore other applications is not ticked.

 

https://support.microsoft.com/en-us/help/274500/-save-changes-in-filename-prompt-even-if-no-changes-are-made

 

Symptoms

When you close a workbook in Microsoft Excel, you may be prompted to save changes to the workbook even if you have not made any changes

Do you want to save the changes to Filename.xls ?

Cause

This behavior occurs when something in the file has changed. Many times the user doesn't realize there are elements in the file that have been updated or calculated. Here are some examples of 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

More Information - Because of this automatic recalculation, Excel prompts you to save changes to the workbook when you close it.

0 comments
41 views

Permalink