Why does Excel ask to Save on Exit?

  • Thread starter Thread starter JRSNHECI
  • Start date Start date
J

JRSNHECI

When I close a couple of excel files it always asks me wheterh I want to
save, even if I have made no changes to the file (i.e. just viewed it).
Other files just close without the prompt. Is there a way to control
how/whether Excel asks you? Thx.
 
You may have some volatile functions in those files - these include NOW,
TODAY and INDIRECT. These will re-calculate whenever the file is opened, so
Excel thinks that the file has changed, even if you do nothing to the file.

Hope this helps.

Pete
 
JRSNHECI said:
When I close a couple of excel files it always asks me wheterh I want to
save, even if I have made no changes to the file (i.e. just viewed it).
Other files just close without the prompt. Is there a way to control
how/whether Excel asks you? Thx.
Click to expand...

It could be that date and time are displayed on worksheet. From the time you
open till the time you close the worksheet the time has changed therefore the
save question. Therefore no need to save.
 
JRSNHECI said:
Is this true for a date function in the footer of the document as well?
Thanks.
Click to expand...
I am no expert but I think it applies to any time you have the date or time
set to automatically adjust. IE: =TODAY() OR=NOW()
 
Even if you double click on any cell, although without making any changes,
the system would ask you to save the file on exit.
 
Back
Top