Turning off prompt to save file with no changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
=====================================================


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
 
Then you must have a macro or an add-in
Have you installed anything from a 3rd party
 
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.
 
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
 
Back
Top