Clarifications on Excel Dependency Tree

Asked By Scott Broek 20 points N/A Posted on - 05/05/2013

 

Kindly look at Excel Dependency Tree and kindly explain to me how Excel determines the dependencies of the cells and formula inputted? How are these immediate updated? 

• Status: Open
• Question Views: 1244
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Johnson Eckhoff

Go To Solution

Best Answer

Best Answer

Answered By Johnson Eckhoff 0 points N/A #136070

Clarifications on Excel Dependency Tree

Hello,

Dependency Trees

Excel tracks changes since the last recalculation and builds dependency trees in an attempt to reduce calculation time. These prompt Excel to recalculate only:

 

 Formulae that have changed.

 Names that have changed.

 Volatile functions.

 Formulae dependent on changed or volatile formulae, names or cells.

 

Dependency trees are immediately updated whenever a formula is entered or changed. In Excel 2002 and later you can force Excel to rebuild the dependency trees by hitting Control+Alt+Shift+F9.

In complex formula-based models, Excel may spend considerable time and memory building and evaluating the dependency trees. In versions prior to Excel 2007 dependency trees will only store up to 65536 dependencies to unique references. Where complex formula-based models near that limit it is not unusual to find full calculation faster than recalculation.

About Johnson Eckhoff

Questions
2

Answers
52

Best Answers
19

• Vote Up 0 Vote Down

• Posted on - 05/19/2013
• Question Category: MS Excel

Answered By Dyer Pearlman 0 points N/A #136071

Clarifications on Excel Dependency Tree

Hi Scott,

Microsoft Excel program is created using .Net language for Microsoft Corporation.  Microsoft usually has a tool for .Net Framework Assembly analyzer.   This tool is open source and you can try to build your own dependency tree.

Follow this link for more

https://drewnoakes.com/code/dependency-analyser/

Here you will find a .NET dependency analyzer. You will run the program and follow the step by step process by selecting appropriate assemblies. You will see pictures that demonstrate this on the link above.

About Dyer Pearlman

Questions
3

Answers
102

Best Answers
62

• Vote Up 0 Vote Down

• Posted on - 05/21/2013
• Question Category: MS Excel