Microsoft KB Archive/24871

From BetaArchive Wiki

Excel: Worksheet vs Macro Sheet Order of Calculation

Last reviewed: October 31, 1994
Article ID: Q24871


Worksheets calculate cells in random order, depending on which supporting values in the sheet have changed.

Macro sheets calculate only when they are executed, and macro cells calculate one after another down a single column [unless a GOTO(), RETURN(), HALT(), or RUN() command or a user-defined function is called].

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.