Making sense of a workbook

Hello everyone

I have inherited a huge workbook with 7 sheets and 300 rows of data with one of the primary calculation sheets having 52 columns. It is a real mess with some hardcoded formulas containing values that need changing depending on the circumstances and other formulas which use calculated values that have upto 15 steps / calculations / references.

It has been "developed" over 7 years by 3 different people none of whom where still at the company when i started and was handed the project of "making sure it works" (there is no documantation).

I have got it to a stage where I know how we most of the essential calculations are worked out but I am still not 100% on where all the standard figures come from.

I was wondering if there was a tool that graphicly portrays links (flowchart?) so that i can identify where all the calculations are coming from and start to put some documentation in place?

Any advice?

click VIEW > TOOLBARS > FORMULA AUDITING
Use the trace precedents and dependents

- Mangesh

Thanks Mangesh

I am currently using this to work out what is going on but it has got to the point that you can hardly see the sheet because of the multitude of arrows that cover it (and thats just following one of the calculations back to its source) and because it jumps between sheets in the workbook so much it is still hard to see what is going on. So i need something more easier on the eye and that I can use to produce a flow chart

Regards

Adrian