Microsoft KB Archive/24871

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:14, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Excel: Worksheet vs Macro Sheet Order of Calculation

Last reviewed: October 31, 1994
Article ID: Q24871

SUMMARY

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

KBSubcategory:

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.