Question regarding Excel Dependency Tree

Asked By 20 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #136067

Question regarding Excel Dependency Tree

qa-featured

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.

Login/Register to Answer

Related Questions