Quit asking if I want to save

[Brad E]

When I open some files just to see the content and then
File>Close without changing a thing or even moving the
active cell, it asks me if I want to save. I realized
this was happening when the file I open was saved in a
previous version. How can I stop it from happening when I
open an Excel 2002 version of a spreadsheet while using
Excel 2002?

Thanks, Brad E.

 

[Gord Dibben]

Brad

Some Excel Functions are volatile. This means they will re-calculate every
time Excel is opened if Calculation is set to automatic thus creating a
"changed" state, which generates the "Save" prompt.

Some volatile Functions to look for.

RAND
AREAS
CELL
COLUMNS
INDEX
INDIRECT
NOW
OFFSET
ROWS
TODAY

Also, as you know, if opening files from older versions into XL 2002 a
re-calculation will be automatic.

Gord Dibben Excel MVP