View links in workbook

M

mbushnell

I hope everyone is well today. I am in a pickle and need some help.
My boss has given me a spreadsheet, which was given to him by his boss.
Basically, I need to figure out how the information flows between the
different tabs (12 or so in total). I have figured out where most of
the information is coming from on the different tabs; however, there is
one tab that seems to be on an island by itsself and does not feed into
any of the other tabs. It seems like it doesn't serve a purpose to me.
I am wondering if there is a way to see if any of the cells in the
other tabs link to this tab. Any help would be greatly appreciated.
Thanks.
 
D

Dave Peterson

First, don't forget to check for any macros that may use that worksheet.

But one way that might work...

Use windows explorer to copy that workbook to a new name (don't damage the
original!).

Then open the copy of that workbook.
Rightclick on the worksheet tab that you want to check.
Move or Copy
Move (not copy!) it to a new workbook and save that workbook.
Close this new workbook (with the copied worksheet).

Now any formulas that refer to that sheet will point at that new workbook.

Now get a copy of Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And use that to look for links to that new workbook. Bill's Findlink will look
through stuff you may not have thought of (like workbook/worksheet names and
charts).

But watch out for formulas like =indirect("'" & a1 & "'!a1"). You may want to
look for errors, too.
 
Top