Prompts to save changes when no changes made

I have several Excel worksheets that when I close them I always get the
prompt 'Do you want to make the changes you made to xxxx.xls?', even if I
haven't made any changes at all. The two sheets I've noticed this with are
sort of large, (>2MB) if that makes any difference.

Is this normal behavior? (Excel2000 SP3 on Win2000 SP4).

--
GPC

Do you have any of these volatile functions in your workbook?

=AREAS()
=INDEX()
=OFFSET()
=CELL()
=INDIRECT()
=ROWS()
=COLUMNS()
=NOW()
=TODAY()
=RAND()

These evaluate with each calculation. And cause excel to think your workbook
has changed.

And excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

Do you have any macros that run automatically that could be changing something?

Cat_in_awe wrote:
>
> I have several Excel worksheets that when I close them I always get the
> prompt 'Do you want to make the changes you made to xxxx.xls?', even if I
> haven't made any changes at all. The two sheets I've noticed this with are
> sort of large, (>2MB) if that makes any difference.
>
> Is this normal behavior? (Excel2000 SP3 on Win2000 SP4).
>
> --
> GPC

--

Dave Peterson

Dave Peterson wrote:
> Do you have any of these volatile functions in your workbook?
>
> =AREAS()
> =INDEX()
> =OFFSET()
> =CELL()
> =INDIRECT()
> =ROWS()
> =COLUMNS()
> =NOW()
> =TODAY()
> =RAND()
>
> These evaluate with each calculation. And cause excel to think your
> workbook has changed.
>
> And excel likes to recalculate workbooks created in earlier versions.
> Is this the case in your situation?
>
> Do you have any macros that run automatically that could be changing
> something?
>

No macros and it's not the earlier version thing (which gives a different
message) , but I have TODAY() in use, so that has to be it. It seemed like
a bug to me, but this explanation makes sense. and I can see why it would
actually be changing something just when you open it. Thanks.

--
GPC

Dave,

Are you sure about Index()?

According to Harlan, it's not.

http://tinyurl.com/bhex8

--
Regards,

RD

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

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Do you have any of these volatile functions in your workbook?
>
> =AREAS()
> =INDEX()
> =OFFSET()
> =CELL()
> =INDIRECT()
> =ROWS()
> =COLUMNS()
> =NOW()
> =TODAY()
> =RAND()
>
> These evaluate with each calculation. And cause excel to think your
workbook
> has changed.
>
> And excel likes to recalculate workbooks created in earlier versions. Is
this
> the case in your situation?
>
> Do you have any macros that run automatically that could be changing
something?
>
> Cat_in_awe wrote:
> >
> > I have several Excel worksheets that when I close them I always get the
> > prompt 'Do you want to make the changes you made to xxxx.xls?', even if
I
> > haven't made any changes at all. The two sheets I've noticed this with
are
> > sort of large, (>2MB) if that makes any difference.
> >
> > Is this normal behavior? (Excel2000 SP3 on Win2000 SP4).
> >
> > --
> > GPC
>
> --
>
> Dave Peterson

=index() didn't cause the prompt in xl2003--I'm not sure if it was volatile in
earlier versions, though. (I would guess it was--there's a kb article with
those functions (minus today()) listed).



RagDyer wrote:
>
> Dave,
>
> Are you sure about Index()?
>
> According to Harlan, it's not.
>
> http://tinyurl.com/bhex8
>
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Do you have any of these volatile functions in your workbook?
> >
> > =AREAS()
> > =INDEX()
> > =OFFSET()
> > =CELL()
> > =INDIRECT()
> > =ROWS()
> > =COLUMNS()
> > =NOW()
> > =TODAY()
> > =RAND()
> >
> > These evaluate with each calculation. And cause excel to think your
> workbook
> > has changed.
> >
> > And excel likes to recalculate workbooks created in earlier versions. Is
> this
> > the case in your situation?
> >
> > Do you have any macros that run automatically that could be changing
> something?
> >
> > Cat_in_awe wrote:
> > >
> > > I have several Excel worksheets that when I close them I always get the
> > > prompt 'Do you want to make the changes you made to xxxx.xls?', even if
> I
> > > haven't made any changes at all. The two sheets I've noticed this with
> are
> > > sort of large, (>2MB) if that makes any difference.
> > >
> > > Is this normal behavior? (Excel2000 SP3 on Win2000 SP4).
> > >
> > > --
> > > GPC
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

well.. from where I'm standing.. you probably have an excel macro
virus.

excel is the worst security risk EVER and Microsoft is too drunk to do
anything about it.

meanwhile; they handicap Access in about a dozen different directions..
when in REALITY; there have only ever been like one access virus; but
hundreds of excel viruses.

just blows my mind.. they are too retarded to do anything about it.

THEY LET YOU EMAIL SPREADSHEETS-- WHEN HUNDREDS, IF NOT THOUSANDS OF
EXCEL VIRUS HAVE BEEN FOUND.

But why cant i email a MDB FILE?
why cant i email an ADP file?

WHAT GIVES MICROSOFT?