Excel - Why does Excel ask to save when no changes were made?

Asked By Mike on 15-Jan-10 03:55 PM
This does not pertain to a new document.  I open an existing document just to
look at it, and when I go to close it, Excel asks if I want to save the
document.  No changes were made, so it should not have to be saved.  it is
annoying.




Mike H replied to Mike on 15-Jan-10 03:57 PM
Mike

One explanation could be that there is a time formula in a cell that has
updated on openeing so the worksheet will have changed.
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''''s razor (Abbrev)
T. Valko replied to Mike on 15-Jan-10 04:18 PM
One cause could be the use of volatile functions in formulas such as:

CELL
INDIRECT
INFO
NOW
OFFSET
OFFSET
RAND
RANDBETWEEN
TODAY

And in certain very rare applications:

INDEX

--
Biff
Microsoft Excel MVP
Jim Thomlinson replied to Mike H on 15-Jan-10 04:22 PM
To be exact if your workbook contains any volatile function (even if the
value calculated does not change) the workbook will be deemed as changed and
a save will be required...

Volatile functions include
Rand, Now, Today, Cell, Offset, Info and Indirect. UDF's can also be
volatile...
--
HTH...

Jim Thomlinson
HpyTrvlr69 replied to Mike on 15-Jan-10 07:45 PM
Mike...
Sometimes Excel will ask you to save if you change the position of the
cursor within the file as well. Hope all these help

HpY