Microsoft KB Archive/26454

{| = Excel: Date Formulas Changing When Worksheet Is Opened =
 * width="100%"|

Last reviewed: November 29, 1994

Article ID: Q26454 The information in this article applies to:
 * Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY
In Microsoft Excel, if the NOW function is used to calculate any date formulas, the calculations will change each time the worksheet is opened.

To prevent formulas from changing each time the worksheet is opened, use a static date instead of the NOW function.
 * }