How do I break or delete a link?

Shelly68

Board Regular
Joined
Sep 12, 2006
Messages
73
We have 2 files that are linked and one of them has been deleted (some 12 or more months ago and only just realised today). It keeps bringing up the box to look for the file.

Can we remove or delete a link within a file?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

JohnnyTightlips

Board Regular
Joined
Aug 13, 2006
Messages
94
if you have Excel 2002+, you can go to Edit > Links and select Break links. It will change the links to hard-coded values. If you are using an older version of Excel, find the file name and use the Find function (CTRL+F) to search for the name across all sheets and break the links manually. Don't forget to look in Named ranges and charts for rogue links!
 

Shelly68

Board Regular
Joined
Sep 12, 2006
Messages
73
Thanks, it worked perfectly.

I love this site, as it teaches me something new everyday.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,916
Messages
5,545,020
Members
410,646
Latest member
LegenDSlayeR
Top