Question regarding Excel Dependency Tree

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

First and foremost, I do not need any recalculations, I only want to know where I could find information like algorithms, procedures and strategies. Kindly look at Excel Dependency Tree for this. I need to build a dependency tree to collect values from the cells that have changed due to some external links and some formula inputted.

• Status: Open
• Question Views: 849
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Mcdonald Larimore 0 points N/A #136067

Question regarding Excel Dependency Tree

Hello Scott,

For the task you want to accomplish, I would suggest you to use excel auditing tools like RefTreeAnalyser which provide a very efficient and accurate way of building dependency trees. RefTreeAnalyser is capable of detecting circular references and displays them in easy to navigate –treeview. This tool also comes with a Report option which can write the current analysis to a new worksheet in the workbook.

Hope you find this useful.

About Mcdonald Larimore

Questions
0

Answers
100

Best Answers
29

• Vote Up 0 Vote Down

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