MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing links


Posted by Carmen on December 01, 2000 5:10 AM

How may I remove the links in a workbook? The problem
is that I have "inherited" a workbook from someone and
it has a lot of useless links when you go to "Edit" and
then "Links".

Thank you very much!


Posted by Salters B. Davis IV on December 02, 2000 1:19 AM

:Remove a hyperlink and the text or graphic that represents it
To remove a hyperlink and the text that represents it, right-click the hyperlink, and click Clear Contents on the shortcut menu.


To remove a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.
Note To remove a hyperlink that was created by using the HYPERLINK workbook function, use the arrow keys to select the cell that contains the formula, and then press DELETE.

How may I remove the links in a workbook? The problem

Posted by Salters B. Davis IV on December 02, 2000 1:20 AM

:Hope that Helps you out somewhat...

How may I remove the links in a workbook? The problem

Posted by John on December 03, 2000 11:39 AM

Microsoft also has an Excel Add-In called dellink.xla that identifies the links in the spreadsheet. You can search their website for the download.

One other trick - check the 'Name' fields box for extraneous named fields (and links) which are no longer relevant to the spreadsheet. The dellink.xla add-in will identify this as a source of the problem, but won't be able to remove it.

Hope this helps.