Unexpected 'Save Changes in Book1' prompt

G

Glynn Taylor

Running Office 2000

Whenever I exit a workbook I now get the following prompt:

'do you want to save the changes you made to Book 1'

I've repaired my Office installation, but this had no effect.

Any ideas?
 
D

Dave Peterson

There are some worksheet functions that are volatile--that are recalculated when
excel recalcs.

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

Any of these functions in formulas could make excel think your workbook has
changed.
 
Top