Discussion Locked

Removing linked files in EXCEL

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have set up a work book with 3 linked files. Over a period of time 1 of the linked files is now obsolete. Now when I open the file I am told to open the obsolete linked file. Using EDIT menu hitting the LINKS option sure enough the obsolete file is listed. The options available only include CREATE UPDATE CHANGE SOURCE. HOW DO I REMOVE THIS OBSOLETE FILE FROM THE LINKS ? Please note I have removed all references to this file in the worksheets of the workbook.
Thanking you in anticipation
Ian Clark

3 replies

by nvpaladin

Go to www.microsoft.com, then to microsoft download center and download the Excel add-in dellinks.exe. The only other way is to go to Microsoft Visual Basic for Applications and do a search and destroy mission. The dellinks should be easier and much faster. Hope this helps

This discussion is closed to new replies.