EXCEL

D

David Crawt

When I save a file WHICH I HAVE MADE NO CHANGES TO, I get a message asking if
I want to save the changes. Surely I should only get this message if I've
made changes
 
T

Tyro

You can get that message if your workbook contains volatile functions such
as NOW(), TODAY() etc. These recompute everytime the workbook is recomputed
and it may appear that nothing has changed when in fact things have changed.


Tyro
 
G

Gord Dibben

If the workbook you opened was created in an earlier version of Excel you will
get the "save changes" message.

Save as your current version.

You will also get the message if you have used any volatile function(s) in your
workbook.

Could be a NOW() or TODAY()

List of volatile functions........

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these would cause the workbook changes.


Gord Dibben MS Excel MVP
 
T

Tyro

I should have pointed out that the volatile functions are recomputed with
the workbook is opened. For example, =TODAY() in a cell returns the current
operating system date. So when you open the workbook, Excel gets today's
date automatically. You did not make any change but Excel did. So when you
close the workbook, if you have not saved it, Excel will ask if you want to
save the changes.

Tyro
 
Top