Excel Dependency Tree

The calculation order of cells in a workbook is governed by an algorithm that tracks cell interdependence. Internally, this calculation order is represented by a dependency tree that is constantly maintained as the user modifies the workbook.

It is this algorithm that allows Excel to automatically recalculate all dependent cells when a preceding cell is modified. For more detailed information on the, see Microsoft description.

Handles vs Dependency Tree

Not all handles can be tracked by Excel's dependency tree. When an immutable handle (either Persistent or Explicit) is generated they will not be recalculated, even if their precedents change. However Named and Anonymous handles will always be recalculated.

Last edited Apr 29, 2013 at 10:17 PM by Tjaart, version 2


No comments yet.