Excel DataFlow UML Viewer/Navigator/Visualiser tool/ hint

Posted by Arjang on Super User See other posts from Super User or by Arjang
Published on 2011-01-17T05:50:37Z Indexed on 2011/01/17 5:54 UTC
Read the original article Hit count: 179

Filed under:
|

Not sure what to call it but, is there a birds eye view tool for excel to show the data flow between excel sheets/cels etc? I have inherited some huge reports and looking at each cell to see where it's data comes from or what sheet/cell dependencies it has is a nightmare.

Or even just something with excel that show the dependencies within a sheet of cells to each other etc.

Or Any other visualization tool that can show the data flow between cells ( I tried visio but it seemed it is only for making diagrams of data not the data model of excel itself ).

Or at least if I am within a cell and see a formula referring to other sheets and cells, is there a quick way to navigate there and back? Like code navigation in VS?

Thank you for your help

© Super User or respective owner

Related posts about excel

Related posts about uml