Avoid popup "Save changes?" when nothing was changed in Excel doc?

[pstein]

Avoid popup "Save changes?" when nothing was changed in Excel doc?

Whenever I open some Excel docs to have a look at the content table and want to close it afterwards WITHOUT CHANGING ANYTHING then Excel (2003/2007) asks me
if I want to save the changes.

I think Excel automatically re-calculates embedded formulas even if I did not type in manually stuff.

So Excel thinks I made some changes.

How can I tell Excel to NOT prompt me any more to save changes if the changes are only based on formula re-calculations ?

If this is not possible: How can I tell Excel to automatically save all changes without prompting me?

Is it possible to setup this preference for ALL excel docs at once rather than for each Excel doc individually ?

Peter

 

[Luckystar]

I don't believe this is possible.

And plus, yes its annoying but without it, there will almost certainly be a time when you will close a document and you will lose everything if you forgot to hit the 'save' button.

Best thing i would say is live with it, it only gives you three option anyway and it only takes two seconds too choose 'yes' or 'no'

Lucky

 

[Trucidation]

Happens all the time in practically any MS Office app. Like I open a Word doc to print, then try to close it. "Save (Y/N)?" even though I didn't edit anything. Ditto Excel. Ditto PowerPoint.

I fully expect that on one fine day I'll hit N out of sheer reflex - and then realize a split second later I just nailed my ass to the wall.