prompted to save when no changes

[goss]

Hi ng
Using xl 2003

I'm reviewing thousands of old spreadsheets to see if I should kee
them or not.

I open the book, take a quick look and close.
I am asked if I would like to save changes, though I did nothing.

What's going on

 

[papou]

Hi
There probably is a "voltatile" function in your worksheet (for instance:
=NOW())

HTh
Cordially
Pascal

 

[Gord Dibben]

Opening "old"(earlier versions) files in Excel 2002 or 2003 will trigger the
"do you want to save" even when their are no volatile functions in use.

AFAIK you cannot turn off this behavior.

Gord Dibben Excel MVP

Hi
There probably is a "voltatile" function in your worksheet (for instance:
=NOW())

HTh
Cordially
Pascal

 

[Dave Peterson]

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

It'll stop excel from recalculating workbooks that were created in earlier
versions when they're opened.

Opening "old"(earlier versions) files in Excel 2002 or 2003 will trigger the
"do you want to save" even when their are no volatile functions in use.

AFAIK you cannot turn off this behavior.

Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks Dave

Vague recollection of this now that you have pointed it out.

Gord