And the winner was.............???

Gord

On 29 Jun 2006 12:14:13 -0700, "loveexcel"
wrote:

Thanks! Found the culprit!


Gord Dibben wrote:
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

On 28 Jun 2006 17:02:35 -0700, "loveexcel"
wrote:

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!

Gord Dibben MS Excel MVP