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