Exiting Worksheet

E

Evan

Some worksheets when exiting ask you if you want to save the file even if no
changes were made to the file some don't. Does anyone know what causes this
and how to shut that feature off?
 
G

Gord Dibben

Evan

Newer versions of Excel like to re-calculate everything when opening a file
created in a previous version.

Does it ask every time even after you complied and saved?

You also could have one or more Volatile Functions that calculate.

There are more Volatile Functions than the average user thinks there are.

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

Also, do you have "Iteration" checked? Uncheck if so.


Gord Dibben Excel MVP
 
Top