Excel closing

[Mayoone]

Why does Excel ask "Do you want to save the changes you
made to ...?" when I didn't make any changes? Can this
be disabled?

 

[Alan]

Do you have =TODAY() or =NOW() in the file? If you do, the value will change
on opening, hence the message.

 

[Peo Sjoblom]

Here's a list of volatile functions

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

 

[Alan]

Thanks Peo, Is that all of them
Alan.

Here's a list of volatile functions

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

--

Regards,

Peo Sjoblom

 

[pfsardella]

http://www.decisionModels.com/calcsecretsi.htm

HTH
Paul