Stop asking to save changes

T

Traci

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

Peo Sjoblom

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
 
J

Jim Rech

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

Traci

Yes, I have the =TODAY().

Peo Sjoblom said:
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
Click to expand...
 
Top