Save Changes ???

[JDH]

Hi,

I have a workbook that I have been using for 2 years now without any issues.
But now after I save changes with the Save button on the formatting toolbar
and try to exit, I receive a message "Do you want to save changes you made to
???.xls". I thought that I had already saved changes. If I open the workbook
just to view my data and made no changes, I still receive the message when I
exit. I have other workbooks that I use and when I exit them I do not receive
the save message. Is there a setting I can change in the program to correct
this?

 

[Gary''s Student]

You may have a function to display
time or date in the workbook somewhere.

For example, if you have a fresh new workbook and insert =NOW() in a cell
and save the result, Excel will ask you if you want to save changes each time
you open/close the workbook, even if you have not changed anything else
yourself.

 

[Gord Dibben]

There are other volatile functions aside from NOW and 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