Trace links between worksheets within one workbook

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
 
G

Gord Dibben

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
 
B

BSc Chem Eng Rick

I presume you don't want to use the "Trace Dependants" and "Trace Precedents"
tools that can be found in formula auditing?
 
B

Bean Counter

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...
 
B

Bean Counter

I FOUND SOMETHING....WWWWOOOOOHHHHOOOOWWWW.... John Walkenbach's ... PUP v6
Addin ...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top