Excel asks to save

M

mjbmacro

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Can anyone tell me why I am asked if I want to save an Excel file that has only been opened to view, and has not been changed. This has just started happening within the last few weeks.
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Can anyone tell me why I am asked if I want to save an Excel file that has
only been opened to view, and has not been changed. This has just started
happening within the last few weeks.
Click to expand...
It is quite likely that the workbook got recalculated on open (especially if
Calculation is set to auto). Recalculation will "dirty" the sheet, making
Excel prompt for a save even when you have not changed anything.
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Can anyone tell me why I am asked if I want to save an Excel file that has
only been opened to view, and has not been changed. This has just started
happening within the last few weeks.
Click to expand...

Do you have any volatile functions? Those recalculate whenever the
workbook is opened, and upon each calculation. XL then will treat that
workbook as if it has new info to be saved.

Among the volatile functions:

NOW()
TODAY()
OFFSET()
RAND()
OFFSET()
CELL()
INDIRECT()
INFO()
 
M

mjbmacro

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Can anyone tell me why I am asked if I want to save an Excel file that has
only been opened to view, and has not been changed. This has just started
happening within the last few weeks.
Click to expand...
It is quite likely that the workbook got recalculated on open (especially if
Calculation is set to auto). Recalculation will "dirty" the sheet, making
Excel prompt for a save even when you have not changed anything.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Your suggestion about calculation being on auto does apply, so it very likely could be the reason for Excels request.[/QUOTE]
 
Top