Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

In Excel 2004 you can trace predecessors etc by selecting a cell then Tools->Auditing->Trace Precedents.

The menu option might differ in other versions of Excel but has been there in other versions. Also in the extras there might be some more auditing functions.

share|improve this answer
    
Thank you, Auditing tools in Excel 2007, on the formulas tab, I can't up vote you cause I don't have enough reputation, but I'll be back. –  Arjang Jan 17 '11 at 21:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.