Trace links between worksheets within one workbook

  • Thread starter Thread starter Bean Counter
  • Start date Start date
B

Bean Counter

Hi Gurus!!

I have a workbook that contains about 20 worksheets. Some of these
worksheets are operations files from other departments, but others are a
consolidation of the data. Not only are there hundreds of links to other
workbooks, but there are hundreds of links between worksheets within the same
workbook. Is there any way I can trace all of these links (aside from doing
it manually)? This document is carrying a lot of extra baggage, and that is
making it extremely difficult for me to understand what is going on.

As I was searching for the answer to this question, I stumbled upon a tool
posted by Bill Manville titled "find links". This is a super cool tool, and
one I am definitely keeping, but it does not give the option on searching
within the same workbook for links. Here is a quick link for those
interested in this handy, dandy tool..

http://www.oaltd.co.uk/MVP/Default.htm
 
FindLink.xla has the function of searching for links to sheets within a
workbook.

You just use the search option and type in the keyword,,,,,,,,,sheet name or
range name.

Other options are listing the links, deleting the links or editing the
links.


Gord Dibben MS Excel MVP
 
I presume you don't want to use the "Trace Dependants" and "Trace Precedents"
tools that can be found in formula auditing?
 
I could use that feature, but I was hoping for a solution that would be a
little less time consuming. There really are hundreds of these links...
 
I FOUND SOMETHING....WWWWOOOOOHHHHOOOOWWWW.... John Walkenbach's ... PUP v6
Addin ...

Does what I was looking for, and sooo much more....
 
Back
Top