Saving Document in Excel

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?
>>
>>
>>