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

On Mon, 17 Mar 2008 23:23:00 -0700, JDH wrote:

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?