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

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

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

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

--
HTH

Bob

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

wrote in message
...



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

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

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.
--
HTH...

Jim Thomlinson


" wrote:




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

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

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

On Tue, 01 Jul 2008 16:52:36 -0500, wrote:




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

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

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

" wrote:




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

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

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

On Jul 1, 10:52*pm, wrote:
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