Saving Document in Excel

Why does excel ask if i want to save a document when i have made no changes?
it happens only with certain workbooks, not all of them. Do I need to change
my settings?

Two possibilities (there may be others)
1. If there is a macro which runs when the file is opened, this effectively
changes the file, even if all the data remains the same.
2. If the file was created with an older version of Excel, you will be
prompted to save the file. I think in this case the message box tells you
why.

--
Ian
--
"Sam" <Sam@discussions.microsoft.com> wrote in message
news:DFBCCB46-9629-4E40-BE5F-428B89838869@microsoft.com...
> Why does excel ask if i want to save a document when i have made no
> changes?
> it happens only with certain workbooks, not all of them. Do I need to
> change
> my settings?

I think it is#2. it does not give a reason in the message box however. will
the save message go away if I paste the doc conents in a new worksheeet?

"Ian" wrote:

> Two possibilities (there may be others)
> 1. If there is a macro which runs when the file is opened, this effectively
> changes the file, even if all the data remains the same.
> 2. If the file was created with an older version of Excel, you will be
> prompted to save the file. I think in this case the message box tells you
> why.
>
> --
> Ian
> --
> "Sam" <Sam@discussions.microsoft.com> wrote in message
> news:DFBCCB46-9629-4E40-BE5F-428B89838869@microsoft.com...
> > Why does excel ask if i want to save a document when i have made no
> > changes?
> > it happens only with certain workbooks, not all of them. Do I need to
> > change
> > my settings?
>
>
>

There is also the case where your sheet contains volatile functions, such
as:

Indirect
Rand
Cell
Offset
Now
Today
Info

These calculate every time you hit <Enter>.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



"Sam" <Sam@discussions.microsoft.com> wrote in message
news:F2579416-35C9-44EA-9E00-377C2B2F5079@microsoft.com...
I think it is#2. it does not give a reason in the message box however. will
the save message go away if I paste the doc conents in a new worksheeet?

"Ian" wrote:

> Two possibilities (there may be others)
> 1. If there is a macro which runs when the file is opened, this
effectively
> changes the file, even if all the data remains the same.
> 2. If the file was created with an older version of Excel, you will be
> prompted to save the file. I think in this case the message box tells you
> why.
>
> --
> Ian
> --
> "Sam" <Sam@discussions.microsoft.com> wrote in message
> news:DFBCCB46-9629-4E40-BE5F-428B89838869@microsoft.com...
> > Why does excel ask if i want to save a document when i have made no
> > changes?
> > it happens only with certain workbooks, not all of them. Do I need to
> > change
> > my settings?
>
>
>

<<<"These calculate every time you hit <Enter>.">>>

I *don't* believe that I typed that!<g>
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:%23RlsphPpGHA.3564@TK2MSFTNGP03.phx.gbl...
There is also the case where your sheet contains volatile functions, such
as:

Indirect
Rand
Cell
Offset
Now
Today
Info

These calculate every time you hit <Enter>.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



"Sam" <Sam@discussions.microsoft.com> wrote in message
news:F2579416-35C9-44EA-9E00-377C2B2F5079@microsoft.com...
I think it is#2. it does not give a reason in the message box however. will
the save message go away if I paste the doc conents in a new worksheeet?

"Ian" wrote:

> Two possibilities (there may be others)
> 1. If there is a macro which runs when the file is opened, this
effectively
> changes the file, even if all the data remains the same.
> 2. If the file was created with an older version of Excel, you will be
> prompted to save the file. I think in this case the message box tells you
> why.
>
> --
> Ian
> --
> "Sam" <Sam@discussions.microsoft.com> wrote in message
> news:DFBCCB46-9629-4E40-BE5F-428B89838869@microsoft.com...
> > Why does excel ask if i want to save a document when i have made no
> > changes?
> > it happens only with certain workbooks, not all of them. Do I need to
> > change
> > my settings?
>
>
>

It will not be #2 if the message box does not appear stating that "this file was
created with an older version of Excel".

Copying to another file will just take the problem over there.

See other answers in this thread.


Gord Dibben MS Excel MVP



On Tue, 11 Jul 2006 07:34:01 -0700, Sam <Sam@discussions.microsoft.com> wrote:

>I think it is#2. it does not give a reason in the message box however. will
>the save message go away if I paste the doc conents in a new worksheeet?
>
>"Ian" wrote:
>
>> Two possibilities (there may be others)
>> 1. If there is a macro which runs when the file is opened, this effectively
>> changes the file, even if all the data remains the same.
>> 2. If the file was created with an older version of Excel, you will be
>> prompted to save the file. I think in this case the message box tells you
>> why.
>>
>> --
>> Ian
>> --
>> "Sam" <Sam@discussions.microsoft.com> wrote in message
>> news:DFBCCB46-9629-4E40-BE5F-428B89838869@microsoft.com...
>> > Why does excel ask if i want to save a document when i have made no
>> > changes?
>> > it happens only with certain workbooks, not all of them. Do I need to
>> > change
>> > my settings?
>>
>>
>>

Sam

There are several Volatile Functions.

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

Any one or more of these would cause the workbook changes.

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 Tue, 11 Jul 2006 07:10:02 -0700, Sam <Sam@discussions.microsoft.com> wrote:

>Why does excel ask if i want to save a document when i have made no changes?
>it happens only with certain workbooks, not all of them. Do I need to change
>my settings?

Gord Dibben MS Excel MVP