prompted to save when no changes

G

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
 
P

papou

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

HTh
Cordially
Pascal
 
G

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
Click to expand...
 
D

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.


Gord said:
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
Click to expand...
 
G

Gord Dibben

Thanks Dave

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

Gord
 
Top