#1   Report Post  
BorisS
 
Posts: n/a
Default unknown links

I have a file with charts (and maybe other things I am not seeing) and it's
filled with links from the charts out. I cannot, by looking at all the
charts manually, find the link that is to the wrong file (although there are
three files that are being referenced which are old). Is there any way to do
a workbook level search of ANY occurence of these that are being referenced,
so I can relink them to newer files? I know that typically formula searches
for all the grouped sheets at once would find it. But I am afraid that with
charts I am missing something.

Thx.
--
Boris
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default unknown links

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

BorisS wrote:

I have a file with charts (and maybe other things I am not seeing) and it's
filled with links from the charts out. I cannot, by looking at all the
charts manually, find the link that is to the wrong file (although there are
three files that are being referenced which are old). Is there any way to do
a workbook level search of ANY occurence of these that are being referenced,
so I can relink them to newer files? I know that typically formula searches
for all the grouped sheets at once would find it. But I am afraid that with
charts I am missing something.

Thx.
--
Boris


--

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
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 12:58 PM
Prompt to update links Werner Rohrmoser Links and Linking in Excel 0 November 3rd 05 09:47 AM
Deleting links to other spreadsheets KarenH Excel Worksheet Functions 2 October 28th 05 04:09 AM
Update links prompt not wanted neeraj Excel Discussion (Misc queries) 5 September 23rd 05 06:34 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM


All times are GMT +1. The time now is 01:26 AM.

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

About Us

"It's about Microsoft Excel"