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

Save as 2007 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



On Mon, 26 Jan 2009 23:23:46 +0000, colwyn
wrote:


Whenever I close an excel 2007 s/s - even if I haven't changed anything
- it asks me if I want to save it. This is driving me nuts!! Anyone
know how I can overcome this problem?
Big thanks.
Colwyn.