Have you tried Tools/ Formula Auditing ?
--
David Biddulph

"GraphicalGuy" wrote in message
...
The layout of complicated Excel spreadsheets can make them difficult to
analyse for logical structure and consistency.

What would be really useful would be a graphical user interface for excel
spreadsheets, along the same lines as that used in Clementine software.

So different columns of data could simply be displayed as "data items",
each
one connected to the others graphically by arrows. These arrows could
symbolise the relationship between the different data items, or operations
being performed to get from one to the next.

In this way, you could "visualise" the flow of calculations in an Excel
spreadsheet, and therefore spot the errors.

Do you know of any such software already in existence that performs this
function?