ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Searching for Linked Cells (https://www.excelbanter.com/excel-discussion-misc-queries/207405-searching-linked-cells.html)

jordanpcpre

Searching for Linked Cells
 
My excel file contains "Links to other Data Sources". Is there anyway to
search for the cell that has a Link to another data source?

TomPl

Searching for Linked Cells
 
Go to <Edit<Links where you will find a list of the sources. Then you can
search the workbook for formulas that contain the name of the workbook linked.

Hope that helps.

Tom

Dave Peterson

Searching for Linked Cells
 
I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

jordanpcpre wrote:

My excel file contains "Links to other Data Sources". Is there anyway to
search for the cell that has a Link to another data source?


--

Dave Peterson

PatK

Searching for Linked Cells
 
Question does Bill Manvilles tool work in Excel 2007? I am "afraid" of
screwing up my excel installation (did that once before with a bad add-in).

Thanks!

patk

"Dave Peterson" wrote:

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

jordanpcpre wrote:

My excel file contains "Links to other Data Sources". Is there anyway to
search for the cell that has a Link to another data source?


--

Dave Peterson


Dave Peterson

Searching for Linked Cells
 
Maybe someone who has tried it in xl2007 will chime in.

PatK wrote:

Question does Bill Manvilles tool work in Excel 2007? I am "afraid" of
screwing up my excel installation (did that once before with a bad add-in).

Thanks!

patk

"Dave Peterson" wrote:

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

jordanpcpre wrote:

My excel file contains "Links to other Data Sources". Is there anyway to
search for the cell that has a Link to another data source?


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 08:46 PM.

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