Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 342
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 96
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching a linked database [email protected] Excel Discussion (Misc queries) 1 May 30th 07 11:11 PM
Searching for string in other cells Ruatha Excel Worksheet Functions 3 June 9th 06 10:42 PM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Is there any way of searching for duplicate cells? Lisa Excel Discussion (Misc queries) 1 October 3rd 05 09:19 AM
Searching for text in cells Matt Excel Discussion (Misc queries) 1 January 31st 05 03:16 AM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"