Why does Excel ask to Save on Exit?


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.
 
Ad

Advertisements

P

Pete_UK

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
 
J

John

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.

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.
 
J

John

JRSNHECI said:
Is this true for a date function in the footer of the document as well?
Thanks.
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()
 
S

Satti Charvak

Even if you double click on any cell, although without making any changes,
the system would ask you to save the file on exit.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top