how to fix: Excel file - you open it, immediately close it, and it still asks if you want to save it

In My Humble Opinion
1

I normally fancy myself a pretty decent Excel guy; I can write the nested IF-THEN formulas, I’m the only one in the office who understands array formulas (“no, you gotta hit CTRL-SHIFT-ENTER”), and I’m somewhat proficient with macros.

But we have a handful of files (multiple tabs, but no obvious external links - “Edit Links” is grayed-out), that whenever you open them - even if you try and immediately close out of them - you still get the “want to Save?” message.

And yes - I get the whole “wow, #firstworldproblems” and all that - but any ideas of what else I could look for? We don’t ever use the TODAY() or NOW() function (that might automatically update a date/time within a cell upon opening), so that’s out.

Any insight into ideas for trying to fix this? Guaranteed personal recognition if you come up with the solution - but of course “that and a quarter…” :smiley:

2

I’ve seen this recently, and have no idea why. It isn’t even consistent! It happens sometimes…but not always!

(In Word, if I save a document as .docx, then save it as .pdf, then try to exit, it asks me if I want to “save changes.” No changes! Why does it ask?)

(Um…what does CTRL-SHIFT-ENTER do?)

3

Have you checked to see if the files in question have an autorun macro in the files?

4

Are you opening it in a more recent version of Excel than it is saved as?

5

This is the commonest reason I have for getting this kind of message. I suspect that there are two solutions:
(1) don’t save the file on closing it, if you have made no changes that you want saved.
(2) save the file as the newer version if you want to avoid having this happen again in the future when you open the file.

6

In that case, it’s pretty simple. Saving as PDF doesn’t save absolutely everything, as it’s not a native Word format. So the software probably marks the file as unsaved when you save that way.

Try doing it the other way around. Save as PDF, then as DOCX.

7

My first guess is that this has nothing to do with the file itself, but with the particular printer that’s defaulted for the machine that you open the file on. When you change the printer “settings” of a file, MS Office programs consider that an edit.

[QUOTE=Trinopus]
In Word, if I save a document as .docx, then save it as .pdf, then try to exit, it asks me if I want to “save changes.” No changes! Why does it ask?)
[/quote]
It asks you this because when you save something as a .pdf you are effectively changing the printer for which the file is formated. That is, saving something as a .pdf is actually a kind of print job.

8

this was my thought. The other is an auto-date =now() formula.