Prompts to save changes when no changes made

  • Thread starter Thread starter Cat_in_awe
  • Start date Start date
C

Cat_in_awe

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).
 
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?
 
Dave said:
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?
Click to expand...

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.
 
=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).


Dave,

Are you sure about Index()?

According to Harlan, it's not.

http://tinyurl.com/bhex8
Click to expand...
 
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?
 
Back
Top