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

--
Thanks for all of the help. It is much appreciated!!!!

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


On Fri, 28 May 2010 08:54:11 -0700, Bean Counter
wrote:

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

I presume you don't want to use the "Trace Dependants" and "Trace Precedents"
tools that can be found in formula auditing?
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Bean Counter" wrote:

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

--
Thanks for all of the help. It is much appreciated!!!!

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...
--
Thanks for all of the help. It is much appreciated!!!!


"BSc Chem Eng Rick" wrote:

I presume you don't want to use the "Trace Dependants" and "Trace Precedents"
tools that can be found in formula auditing?
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Bean Counter" wrote:

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

--
Thanks for all of the help. It is much appreciated!!!!

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

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


--
Thanks for all of the help. It is much appreciated!!!!


"BSc Chem Eng Rick" wrote:

I presume you don't want to use the "Trace Dependants" and "Trace Precedents"
tools that can be found in formula auditing?
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Bean Counter" wrote:

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

--
Thanks for all of the help. It is much appreciated!!!!