View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
opieandy opieandy is offline
external usenet poster
 
Posts: 32
Default 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