Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to build Dependency Trees in Excel
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Build a search tool in excel | Excel Worksheet Functions | |||
Is there a way to build a timeline PPT spread sheet from excel | Excel Worksheet Functions | |||
Merge using Excel 2002 and Hummingbird Docs Open 3.9.0 Build 199 | Excel Discussion (Misc queries) |