On Exit, always asked to save
 

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!

On Exit, always asked to save
 

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!

On Exit, always asked to save
 

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!

On Exit, always asked to save
 

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