Save changes?

[Harvey Waxman]

When I open this particular workbook and close it I am always asked if I
want to save changes. I didn't make any changes at all yet I am always
asked this question.

Using Office X and Leopard. It always did this under earlier OS's as
well.

Suggestions?

 

[JE McGimpsey]

When I open this particular workbook and close it I am always asked if I
want to save changes. I didn't make any changes at all yet I am always
asked this question.

Using Office X and Leopard. It always did this under earlier OS's as
well.

Suggestions?

Don't use volatile functions...

Functions such as OFFSET, TODAY, NOW, RAND, ROWS, COLUMNS, CELL, and one
or two others always recalculate when the workbook is opened.

Even if the value didn't change (e.g., TODAY() returns the same value in
the morning and the afternoon), the workbook will be "dirty" and
indicate that it requires a save decision.

 

[Harvey Waxman]

Functions such as OFFSET, TODAY, NOW, RAND, ROWS, COLUMNS, CELL, and one
or two others always recalculate when the workbook is opened.

That explains it. I have "TODAY" in many cells. I guess I'll live with
it.

Thanks