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
|