On Exit, always asked to save

[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!

[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

On 28 Jun 2006 17:02:35 -0700, "loveexcel" <christinea@americanmedibanc.com>
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!

[loveexcel]

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" <christinea@americanmedibanc.com>
> 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]

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

Gord

On 29 Jun 2006 12:14:13 -0700, "loveexcel" <christinea@americanmedibanc.com>
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" <christinea@americanmedibanc.com>
>> 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