How to remove links in Excel

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

How to remove links in Excel

Post by BittenApple »

Hello team,
I have an excel workbook, while it is being opened, it says, it is linking to another workbook. How to find this link and break it?
Regards,
Bitten :scratch: :scratch: :scratch: :scratch:

User avatar
StuartR
Administrator
Posts: 12605
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: How to remove links in Excel

Post by StuartR »

On the Data Tab, click Edit Links. Select each link (or all at once) and click Break Link
StuartR


BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: How to remove links in Excel

Post by BittenApple »

Thanks!

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: How to remove links in Excel

Post by BittenApple »

Hello StuartR,
I have Excel 365, under data tab, I can't see edit links.
Any clue?
Regards,
BittenApple

User avatar
HansV
Administrator
Posts: 78481
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to remove links in Excel

Post by HansV »

Select File, then click Info.
"Edit Links to Files" should be near the bottom right corner.

S0713.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: How to remove links in Excel

Post by BittenApple »

Hello Hans,
It is not there in office 365.
I can't find it.
Regards,
Bitten

User avatar
HansV
Administrator
Posts: 78481
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to remove links in Excel

Post by HansV »

BittenApple wrote:
27 Aug 2021, 05:25
I have Excel 365, under data tab, I can't see edit links.
It should be in the Queries & Connections group, probably the last item in that group.
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12605
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: How to remove links in Excel

Post by StuartR »

This is where it is for me...
You do not have the required permissions to view the files attached to this post.
StuartR


User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15619
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: How to remove links in Excel

Post by ChrisGreaves »

BittenApple wrote:
06 Sep 2021, 17:39
It is not there in office 365.
Hello Bitten,
I found it in Excel2003 by using the Excel search box looking for "links".
Untitled.png
Cheers
Chris
You do not have the required permissions to view the files attached to this post.
There's nothing heavier than an empty water bottle

User avatar
HansV
Administrator
Posts: 78481
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to remove links in Excel

Post by HansV »

This apple was bitten more than seven months ago...
Best wishes,
Hans