1.

What Is Excel Dependency Tree?

Answer»
  • DEPENDENCY trees are EXCEL way of minimizing the calculation by TRACKING what has changed since last calculation. It allows Excel to recalculate only:
  1. Formulae/Names that have changed.
  2. Formulae containing VOLATILE Functions.
  3. Formulae dependent on changed or volatile formulae or cells or names.
  • Excel determines dependencies by LOOKING at the cells referred to by each formula and by the argument list of each function.
  • Dependency trees are immediately updated whenever a formula is entered or changed.
  • To force the dependency trees to be rebuilt and all formulae calculation use CTRL+ALT+SHIFT+F9.


Discussion

No Comment Found

Related InterviewSolutions