why does excel ask if I want to save every time?

[colwyn]

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.

 

[Gord Dibben]

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

 

[Sheeloo]

Are you working with a file created in Excel 2007 (will have XLS extenstion)?

If yes, then save it as an Excel file (XLSX extension) and your 'problem'
will go away.
Excel 2007 has to convert the XLS file to its native format hence the file
is marked as changed which promots the Save dialog.

 

[colwyn]

Thanks guys but the problem persists
Sheeloo, yes it was created in Excel 2007 and it has xlsm extension

Gord Dibben, there are none of those "volatile functions" within th
s/s

There are formulas which reference 2003 s/s workbooks. Would this b
why I'm being asked to save unchanged Excel 2007 workbooks
Is there any way I can prevent this
Big thanks
Colwyn

 

[Bill Sharpe]

Thanks guys but the problem persists.
Sheeloo, yes it was created in Excel 2007 and it has xlsm extension.

Gord Dibben, there are none of those "volatile functions" within the
s/s.

There are formulas which reference 2003 s/s workbooks. Would this be
why I'm being asked to save unchanged Excel 2007 workbooks?
Is there any way I can prevent this?
Big thanks.
Colwyn.

An xlsm file has embedded macros. Perhaps the macro is changing
something to cause the "save as" prompt.

Otherwise, the Esc key should dismiss the save dialog box easily. Don't
sweat the small stuff!

Bill