If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Removing links
I inherited a workbook that has a link to another workbook that no longer
exists. Every time I open this workbook, a message pops up that it can't find the linked file. I don't need to be linked to the other file, how do I remove this link? Dino |
#2
|
|||
|
|||
Hi Dino,
Try going to the "Insert" pull-down menu, then select "Name", then "Define...". Look to see if there is anything in the list that shouldn't be there. Hope that helps. Regards, James "Dino" wrote: I inherited a workbook that has a link to another workbook that no longer exists. Every time I open this workbook, a message pops up that it can't find the linked file. I don't need to be linked to the other file, how do I remove this link? Dino |
#3
|
|||
|
|||
It worked! I discovered some names there and deleted them. No more pop-up.
Thank you. Dino "JS2004R6" wrote: Hi Dino, Try going to the "Insert" pull-down menu, then select "Name", then "Define...". Look to see if there is anything in the list that shouldn't be there. Hope that helps. Regards, James "Dino" wrote: I inherited a workbook that has a link to another workbook that no longer exists. Every time I open this workbook, a message pops up that it can't find the linked file. I don't need to be linked to the other file, how do I remove this link? Dino |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing a group of hypertext links or all hypertext links in a document | Terri Creagh | Formatting Long Documents | 5 | November 9th, 2004 05:30 AM |
Removing a group of hypertext links or all hypertext links in a document | Terri Creagh | General Discussion | 5 | November 9th, 2004 05:30 AM |
Removing a group of hypertext links or all hypertext links in a document | Terri Creagh | Tables | 5 | November 9th, 2004 05:30 AM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Removing external links in Excel | Tom Carnahan | Links and Linking | 1 | February 23rd, 2004 09:26 AM |