On Exit, always asked to save

L

loveexcel

I have a worksheet that whenever I open it to view only, I am asked if
I want to save when I exit the file. I am not making any changes. Is
there a way to find the field that is updating automatically? I'm
assuming there must be a field like: ()now that is automatically
changing and this is why Excel then asks if I want to save my changes.
But like I said, I am not making any changes.

Thanks for your help!
 
G

Gord Dibben

There are several Volatile Functions.

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these could be the culprit.

You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle
View Formulas on and do a look search by eyeball.


Gord Dibben MS Excel MVP
 
L

loveexcel

Thanks! Found the culprit!


Gord said:
There are several Volatile Functions.

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these could be the culprit.

You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle
View Formulas on and do a look search by eyeball.


Gord Dibben MS Excel MVP
Click to expand...
 
Top