View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Why does Excel ask to Save on Exit?

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" wrote in message
...
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.