Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
"Save changes in <filename>" prompt even if no changes are made
Article ID: 274500 - View products that this article applies to.
This article was previously published under Q274500
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 ?
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:
Because of this automatic recalculation, Excel prompts you to save changes to the workbook when you close it.
Opening a file in a newer version
For more information on how Excel recalculates the file the first time it is opened in a new version see the following KB.
(http://support.microsoft.com/kb/http://support.microsoft.com/kb/210162/[anySimpleType]/ )Workbook loads slowly the first time that it is opened in Excel
Note: Turning your calculation will not stop a calculation of the file the first time it is loaded in the newer version of Excel.
Volatile Functions in Excel
List the most popular volatile functions that maybe in the file.
Note: Setting your calculation option to Manual will stop this behavior but your formulas will not update as expected.
CELL() OFFSET() TODAY() INDIRECT() NOW() INFO() RAND()
The CELL() function is not considered volatile in some situations, even though it causes this behavior.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/211370/ )CELL function with "filename" no longer volatile
When you close a workbook that contains a chart of any type, Excel prompts you to save changes to the workbook. This is because of the way that Excel handles charts.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 274500 - Last Review: October 18, 2012 - Revision: 5.0