Unexpected 'Save Changes in Book1' prompt

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top