ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can you remove a redudant Excel link (https://www.excelbanter.com/excel-worksheet-functions/63997-how-can-you-remove-redudant-excel-link.html)

PX

How can you remove a redudant Excel link
 
I have changed an excel file and deleted a formula containing a link but the
link still remains in the Edit Links option and is also prompted as one of
many links when the file is opened.

How can this be? A search of the entire workbook for the file named in the
link returns data not found. This has happened in several workbooks and one
such link is biarrely to a Visio file.



Gary L Brown

How can you remove a redudant Excel link
 
From previous posings...
Download Bill Manville's FINDLINK addin that will let you do just about
anything you ever wanted with a link. Freely available from:-
http://www.bmsltd.co.uk/MVP/Default.htm

Bill's the best at exactly your type of issue!

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"PX" wrote:

I have changed an excel file and deleted a formula containing a link but the
link still remains in the Edit Links option and is also prompted as one of
many links when the file is opened.

How can this be? A search of the entire workbook for the file named in the
link returns data not found. This has happened in several workbooks and one
such link is biarrely to a Visio file.




All times are GMT +1. The time now is 12:47 AM.

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