SUBJECT: Removing links to other Spreadsheets I seem to...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Perry
Submitted on 1/26/2004
Related FAQ: comp.apps.spreadsheets FAQ
Rating: Not yet rated	Rate this question:
SUBJECT: Removing links to other Spreadsheets I seem to have picked up a link to a remote workbook which no longer exists on my computer and a link I do not require. The result being that each time I load this particular workbook is comes up with the following message: “The workbook you opened contains automatic links to information in another workbook. Do you want to update with changes made to the other workbook?” I need to know how to remove this link because I’ve been through the worksheets and can’t find a link to this so-called “Phantom” file.

Answer by Richard
Submitted on 1/28/2004
Rating: Not yet rated	Rate this answer:
No Idea, I would like to know also

Answer by Hasan
Submitted on 1/29/2004
Rating:	Rate this answer:
There are few options for searching the link. 1. Go to Edit and then Link, if you have Excle XP then you will have the option "Break the Link" which will automaticly remove the link. 2. If you do not have the XP version then Press Ctrl F and type "Phantom" in the box and click find. Excle will automaticly stop on the cell which has that link in. If you have more then one tab in this file then you have to rapeat this action on each sheet.

Answer by Hasan
Submitted on 1/29/2004
Rating: Not yet rated	Rate this answer:
There are few options for searching the link. 1. Go to Edit and then Link, if you have Excle XP then you will have the option "Break the Link" which will automaticly remove the link. 2. If you do not have the XP version then Press Ctrl F and type "Phantom" in the box and click find. Excle will automaticly stop on the cell which has that link in. If you have more then one tab in this file then you have to rapeat this action on each sheet.

Answer by Uncle Pooh
Submitted on 2/19/2004
Rating:	Rate this answer:
I saw this article ... the FindLink program helped me solved my problem. Good luck http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_20800396.html

Answer by Tess
Submitted on 4/15/2004
Rating:	Rate this answer:
Both ZDNet.com (who was first with it) and now Microsoft have an applet you can download--Dellinks.exe, which I needed for Excel97, which I still use. Wizard & instructions are explicit enough to help you immediately. When using it for the first time, be sure you "unhide" your personal.xls wkbk and close it. It won't work otherwise. The process will save a copy of the workbook containing the description & location of the links removed should you wish to restore any of them.

Answer by Henk
Submitted on 8/18/2004
Rating: Not yet rated	Rate this answer:
Easy method that USUALLY works: Open Filename.xls (your file). Save as Filename1.xls (put a 1 behind the name, now you have 2 files). With Filename1.xls open, hit Edit-Links. Change links to go to Filename.xls. Save file. Close it. Delete filename.xls Rename filename1.xls to filename.xls

Answer by Ryan
Submitted on 8/15/2005
Rating: Not yet rated	Rate this answer:
You can also re-direct the link to the currently opened workbook and excel removes the link

Answer by Swut
Submitted on 11/7/2005
Rating: Not yet rated	Rate this answer:
Just came across the same problem with "phantom" links in excel 2000. Even after searching and deleting all the links, Excel thought they still existed. I went to "edit"/"links"/"change source" and changed the reference to my current workbook. That deleted all of the links.

Answer by joop
Submitted on 3/7/2007
Rating: Not yet rated	Rate this answer:
Dellinks.exe workes for me. Thanx

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: