I have taken over a very involved financial workbook. There are very many
pages and they are all linked to other sheets within the same workbook.

I am trying to understand the data and on an individual page I would like to
know what sheets it is linked to.

Is there a macro or something that will go through my page and then tell me
all the sheets that are linked to it. How it displays this I am not bothered
about.

Many thanks in advance.

fullers,
If you to ToolsOptionsView and check Formulas, then formulae rather than
values will display.
There also ToolsAuditing, but I've never really used it.

NickHK

"fullers" wrote in message
...
I have taken over a very involved financial workbook. There are very many
pages and they are all linked to other sheets within the same workbook.

I am trying to understand the data and on an individual page I would like
to
know what sheets it is linked to.

Is there a macro or something that will go through my page and then tell
me
all the sheets that are linked to it. How it displays this I am not
bothered
about.

Many thanks in advance.

http://www.oaltd.co.uk/MVP/Default.htm
Go to this site and download the Add-in find links
this will find links from work book to workbook as well as links to
worksheet to work sheet,

Also Ctrl and ` will show all formulas on the sheet(thats the key
beside the 1 key)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520492