Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off prompt to save file with no changes
How do you turn off the prompt that asks whether you want to save changes,
when no changes have been made? Some files automatically prompt you for this even when you open and then immediately close the file, while others don't. Thanks, Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off prompt to save file with no changes
Those particular sheets have volatile functions in them, like Offset,
Indirect, Now, among many others. These functions calculate even though their own values don't change. So ... in reality, the sheet *is* changed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "opieandy" wrote in message ... How do you turn off the prompt that asks whether you want to save changes, when no changes have been made? Some files automatically prompt you for this even when you open and then immediately close the file, while others don't. Thanks, Chris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off prompt to save file with no changes
RD,
No, this occurs when I open and close a new blank worksheet. Any other ideas? Chris "RagDyeR" wrote: Those particular sheets have volatile functions in them, like Offset, Indirect, Now, among many others. These functions calculate even though their own values don't change. So ... in reality, the sheet *is* changed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "opieandy" wrote in message ... How do you turn off the prompt that asks whether you want to save changes, when no changes have been made? Some files automatically prompt you for this even when you open and then immediately close the file, while others don't. Thanks, Chris |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off prompt to save file with no changes
Then you must have a macro or an add-in
Have you installed anything from a 3rd party -- Regards, Peo Sjoblom "opieandy" wrote in message ... RD, No, this occurs when I open and close a new blank worksheet. Any other ideas? Chris "RagDyeR" wrote: Those particular sheets have volatile functions in them, like Offset, Indirect, Now, among many others. These functions calculate even though their own values don't change. So ... in reality, the sheet *is* changed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "opieandy" wrote in message ... How do you turn off the prompt that asks whether you want to save changes, when no changes have been made? Some files automatically prompt you for this even when you open and then immediately close the file, while others don't. Thanks, Chris |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off prompt to save file with no changes
No, I haven't installed anything from a third party. Still not sure why that
would affect some files but not others, particularly a blank worksheet. "Peo Sjoblom" wrote: Then you must have a macro or an add-in Have you installed anything from a 3rd party -- Regards, Peo Sjoblom "opieandy" wrote in message ... RD, No, this occurs when I open and close a new blank worksheet. Any other ideas? Chris "RagDyeR" wrote: Those particular sheets have volatile functions in them, like Offset, Indirect, Now, among many others. These functions calculate even though their own values don't change. So ... in reality, the sheet *is* changed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "opieandy" wrote in message ... How do you turn off the prompt that asks whether you want to save changes, when no changes have been made? Some files automatically prompt you for this even when you open and then immediately close the file, while others don't. Thanks, Chris |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off prompt to save file with no changes
A worksheet is not a file.
A workbook is a file and can contain multiple worksheets. Exactly what are you opening and from where when you say "blank worksheet"? Gord Dibben MS Excel MVP On Wed, 23 May 2007 13:21:01 -0700, opieandy wrote: No, I haven't installed anything from a third party. Still not sure why that would affect some files but not others, particularly a blank worksheet. "Peo Sjoblom" wrote: Then you must have a macro or an add-in Have you installed anything from a 3rd party -- Regards, Peo Sjoblom "opieandy" wrote in message ... RD, No, this occurs when I open and close a new blank worksheet. Any other ideas? Chris "RagDyeR" wrote: Those particular sheets have volatile functions in them, like Offset, Indirect, Now, among many others. These functions calculate even though their own values don't change. So ... in reality, the sheet *is* changed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "opieandy" wrote in message ... How do you turn off the prompt that asks whether you want to save changes, when no changes have been made? Some files automatically prompt you for this even when you open and then immediately close the file, while others don't. Thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turning always save backup file to off | Setting up and Configuration of Excel | |||
Prompt to save file | Setting up and Configuration of Excel | |||
Turning off "save changes" prompt | Excel Discussion (Misc queries) | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Prompt for Save when closing a file | Excel Discussion (Misc queries) |