Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |