Excel asks to save changes when noen are made

[dOinK]

I have several spreadsheets that make Excel (2003) ask whether to save the
changes before closing the file, even if no changes are made (e.g. open the
file and close it - or select exit - without doing anything else).

I have pinned down one cause of this; it seems that the OFFSET function can
make Excel behave this way (e.g. an otherwize blank spreadsheet with the
function =offset(a1,12,0) ).

- Is there a way to avoid this question (unless I have made changes)?
- Why does Excel think that changes have been made?

dOinK

 

[Frank Kabel]

Hi
you probably have some volatile functions in your spreadsheet (e.g.
like OFFSET). These are re-calculated then opening your file. Therefore
Excel recognizes a change and asks for saving these changes. See:
http://www.decisionmodels.com/calcsecretsi.htm

 

[dOinK]

Interesting stuff, thanks!

dOinK