View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Excel asks to save an unchanged document. Why?

Perhaps you have one or more "Volatile" functions that calculate when the
workbook is opened.

These could include

Volatile Functions.....................

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

If such is the case, you can stop the warning only if you find these functions
and change them to fixed values by copypaste specialvalues


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 13:04:02 -0700, kkp wrote:

Whenever I try to close an Excel documnet that I havent made any changes to,
Excels asks me if I would like to save the document? Why? Can I stop this?


Gord Dibben MS Excel MVP