Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Search for links
Posted by JC on December 14, 2001 3:04 PM
When I open a file it promts me to update with links from another file. Of course I am familiar with this function of excel, but I have no idea how to locate the links. I didn't create the file, and if there are any links in the file I need to remove them....can someone help me find them?
Thanks<
JC</div><img src="blueline.jpg">
Re: Search for links
Posted by Dan on December 14, 2001 3:09 PM
To see where your workbook is linking, go to Edit, Links and that will display what workbooks are linked to the workbook you have open. If you search Microsoft's support site, you can find an add-in to download that will help you delete links automatically. Otherwise it can be a little tricky to find them all.
Re: Search for links
Posted by JC on December 14, 2001 3:42 PM
Unfortunately this doesn't help. I'm not looking to find what the file is linked to - I need to find where in the file the link is embeded. Anyone else have any thoughts? My only current idea is to change the view to show formulas and manualy search out the links.
Re: Search for links
Posted by Juan Pablo G. on December 14, 2001 3:58 PM
One thing i did. Select all sheets, Edit, Find, look for something like
=[
or something like that, it should take you to the formula(s) that has links to external books.
Juan Pablo G.
Re: Search for links
Posted by sandra mangunsong on December 17, 2001 12:39 AM
Hi there
try search in google with keyword FindLink xla
The code is to show any link you want to find
even a phantom link.
sandra
Re: Search for links
Posted by sandra on December 17, 2001 12:49 AM
Try also this
http://support.microsoft.com/support/kb/articles/Q188/4/49.ASP?LN=EN-US&SD=gn&FR=0&qry=dellinks&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97
Sandra
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.