General discussion

Locked

Removing linked files in EXCEL

By ian.o.clark ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Removing linked files in EXCEL

by NVPaladin In reply to Removing linked files in ...

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

Collapse -

Removing linked files in EXCEL

by ian.o.clark In reply to Removing linked files in ...

Very helpful thanks NV.

Collapse -

Removing linked files in EXCEL

by ian.o.clark In reply to Removing linked files in ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums