Save changes?

H

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?
 
J

JE McGimpsey

Harvey Waxman said:
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?
Click to expand...

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.
 
H

Harvey Waxman

JE McGimpsey said:
Functions such as OFFSET, TODAY, NOW, RAND, ROWS, COLUMNS, CELL, and one
or two others always recalculate when the workbook is opened.
Click to expand...

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

Thanks
 
Top