ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find cell in Excel2000 workbook with link from another workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/205477-find-cell-excel2000-workbook-link-another-workbook.html)

Mark4mmx

Find cell in Excel2000 workbook with link from another workbook?
 
Hi all,
I'm trying to locate a cell in a workbook "A" which contains a link to
workbook "B". Edit Links tells me there is at least one cell in "A"
referring to a cell in "B". "A" is a large workbook. How can I quickly and
easily locate the cell or cells?
Many thanks for any assistance!

Dave Peterson

Find cell in Excel2000 workbook with link from another workbook?
 
I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

But you may get lucky and be able to search for workbook b's name.

Mark4mmx wrote:

Hi all,
I'm trying to locate a cell in a workbook "A" which contains a link to
workbook "B". Edit Links tells me there is at least one cell in "A"
referring to a cell in "B". "A" is a large workbook. How can I quickly and
easily locate the cell or cells?
Many thanks for any assistance!


--

Dave Peterson


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com