Not INDEX, it became non volatile with excel 97


Peo


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