View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Forced to save - even if no changes

If the workbook you opened was created in an earlier version of Excel you will
get the "save changes" message.

Save as your current version.

You will also get the message if you have used any volatile function(s) in your
workbook.

Could be a NOW() or TODAY()

List of volatile functions........

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these would cause the workbook changes.


Gord Dibben MS Excel MVP

On Wed, 12 Dec 2007 18:26:03 -0800, RJB wrote:

I have one file that when I close it, it always asks me if I want to save
changes, even if I didn't even breathe while it was open. What gives?