Try Tools - Formula auditing

" wrote:

Hi i wanted to know where to find information like algorithms,
procedures, strategies regarding the Excel dependency Trees. (I donot
need it for recalculation.)
I need to build a dependency tree to collect values from the cells
that have changed due to external links/ formula. Although the
documentation for SheetChange event specifies that the event fires for
cell change due to external link.. it does nt. SheetChange event fires
only for Cells that change due to manual entry.

So when a Cell say A1!Sheet1 that acts as input to a few other Cells(
cells in other Sheets) in the workbook changes, i need to build a
dependency tree which gives all the cells in a workbook that get
effected because of
A1!Sheet1.

With Regards
daffo