Stop asking to save changes
 

How do I get Excel (2000) to stop asking me if I want to save changes when
I've made no changes? I saw this issue addressed in Word, but the "fix" must
not be the same in Excel, because I couldn't find it.

If you have any volatile functions in the workbook it will always ask if you
want to save, things like =NOW(), =TODAY(), OFFSET() etc
Do you have any formulas like that?


Regards,

Peo Sjoblom

"Traci" wrote in message
...
How do I get Excel (2000) to stop asking me if I want to save changes when
I've made no changes? I saw this issue addressed in Word, but the "fix"
must
not be the same in Excel, because I couldn't find it.

Sometimes just a calc constitutes a change as far as Excel is concerned.
For instance if the workbook was last calced in an earlier version of Excel
or if you used any 'volatile' worksheet functions like Offset.

While you can block the prompt with a Before_Close event macro it's not a
good idea since it would block legitimate warnings too.

--
Jim
"Traci" wrote in message
...
| How do I get Excel (2000) to stop asking me if I want to save changes when
| I've made no changes? I saw this issue addressed in Word, but the "fix"
must
| not be the same in Excel, because I couldn't find it.

Yes, I have the =TODAY().

"Peo Sjoblom" wrote:

If you have any volatile functions in the workbook it will always ask if you
want to save, things like =NOW(), =TODAY(), OFFSET() etc
Do you have any formulas like that?


Regards,

Peo Sjoblom

"Traci" wrote in message
...
How do I get Excel (2000) to stop asking me if I want to save changes when
I've made no changes? I saw this issue addressed in Word, but the "fix"
must
not be the same in Excel, because I couldn't find it.