Why do certain worksheets ALWAYS ask if I want to save them when closing them?

[glbecker12]

When exiting certain worksheets, Excel always asks
if I want to SAVE my changes even though I did not
make changes to current worksheet. What do I have
set wrong?

It only happens on certain spreadsheets.

Thanks

Using Excel 97

 

[Bob Phillips]

Volatile functions, like TODAY(), NOW()?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jim Thomlinson]

A couple of possible reasons but by far the most likely is that you have a
volatile function in the spreadsheet somewhere. Volatile functions are
functions that re-calc with any calculation. Examples are functions like
Now(), Row(), Indirect( ) or Offset(,,,,).

Because they have recalced the spreasheet is deemed to have changed even if
the function returns the same value as it originally had.

 

[Gord Dibben]

In addition to the copule of volatile functions Bob listed..................

List of volatile functions........

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these would cause the workbook changes.


Gord Dibben MS Excel MVP

 

[Bigfoot17]

Or type something into a blank cell, then delete it and close file. To you
the sheet has not changed but not to Excel.

 

[Pete_UK]

I think in Excel 97 INDEX was a volatile function as well.

Another likely cause - open the file, choose from a pull-down filter
option to check a value, then close the file. Again, Excel thinks the
file has changed.

Pete