Unexpected 'Save Changes in Book1' prompt

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glynn Taylor - 17 Jul 2007 09:26 GMT

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?

Reply to this Message

Dave Peterson - 17 Jul 2007 12:42 GMT

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.

> Running Office 2000
>
[quoted text clipped - 5 lines]
>
> Any ideas?

Signature

Dave Peterson

Reply to this Message