Why does this Excel file keep asking to save?

A client sent me some Excel .xlsx documents, and every time I open one of them and then close it, Excel asks if I would like to save changes, even if I didn't make any. This doesn't happen with any of my other Excel files. What is going on?

The files have no macros. I use Excel 2007.

5

10 Answers

Copying from here:

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.

This list contains the cases mentioned in other answers as possibilities, and some others as well.

1

One possibility is that the .xlsx file contains external links in at least one cell. Eg

Normally if you open this file you will be prompted with...

However, there is an annoying setting that throws people off in DATA/EDIT LINKS/START UP PROMPT/Dont display the alert and update links which overrides this prompt

Unfortunately, when you close the workbook you still get the prompt to save which will update the links.

This is one possible clue..?

EDIT:

Another possibility is the .xlsx contains a date formula such as NOW() or TODAY() which will prompt a save upon closing

2

I was experiencing this problem on a Windows 7 PC and using Microsoft Office 2007.

I also have the MySQL 5.6 database server software on this PC.

While investigating the problem, I found that I had installed the MySQL for Excel 1.3.4 component and that this resulted in a "MySQL for Excel" add-in showing up in Excel.

Because I wasn't actually using this component, I went to the MySQL Installer and removed it. After doing so, I found that the "Do you wish to save ..." prompts stopped appearing (i.e. if I merely viewed a spreadsheet without modifying it).

Hope this helps...

2

None of the reasons anyone gave in any forum was the reason I was seeing this issue. I painstakingly moved little pieces from one workbook to another until the culprit revealed itself.

Someone had cut and pasted text into a sheet. The problem was that the text ended up as a floating shape with text in it, instead of going into a cell.

They are easy to see once you know they are there. Select all rows (so they appear with a light blue background). Then the labels or pictures or whatever, will stick out like white blocks. At least that is how it appeared for me. Your mileage may vary.

This ends a long and frustrating battle with excel.

1

It's likely that the .xlsx file was recalculated automatically when you opened it in Excel. Go to the Data tab to turn off automatic recalculation.

1

File > Option > Formula > Automatic

Change to

File > Option > Formula > Manual

OR

Formulas > Calculation Options > Automatic to Manual

There are two answers that I use to kill the request to save, both have been covered but bear repeating:

1. For an older version xls or xlsx file, Save as xlsx and over-write the file. This almost always kills it with files I get from others.

2. In Formulas, Calculation Options, set to Manual. This worked on a large file of mine with about 50 tabs, when finding out which tab was causing the problem was too much trouble. Thanks to whoever above suggested this as it has been annoying me for 5 years! I would have commented and thanked you but apparently I do not have enough brownie points to do this.

I had this problem, turned out there was some vba in the "worksheet" in the vba editor. Removed the code from there and then worked like a charm.

1

In my case, I had a data1.xlsx (Excel workbook format). I Opened it, file/save as data1.xls (excel 97-2003 format) (Not .xlsx). and the problem went away. I also have the mysql addin and did not have to remove/uninstall it. I use excel 2007.

0

I had a similar issue. In my case, I had PivotTables in the workbook that had the "Refresh data when opening the file" option active, which was the default option when I created the PivotTables in the first place. Unchecking that option for each PivotTable solved the issue. Perhaps this will help. See the following PivotTable Options image.

1