N/APosted 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.
Question regarding Excel Dependency Tree
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.