If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trace links between worksheets within one workbook
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!!!! |
#2
|
|||
|
|||
Trace links between worksheets within one workbook
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 |
#3
|
|||
|
|||
Trace links between worksheets within one workbook
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!!!! |
#4
|
|||
|
|||
Trace links between worksheets within one workbook
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!!!! |
#5
|
|||
|
|||
Trace links between worksheets within one workbook
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!!!! |
Thread Tools | |
Display Modes | |
|
|