Delete Links in Excel 2010

[GrilledCheese]

I have a workbook with many links. I go to Data, Edit Links, Break Links. Now, I want to delete the link so that it does not show anymore. How do I go about doing that?

 

[cyrilbrd]

Hi, have you read that blog? link (pun intended...)

 

[GrilledCheese]

I know how to find and break links. But now, I want to delete the links so that it doesn't show up under "edit links".

Hi, have you read that blog? link (pun intended...)

 

[cyrilbrd]

Open the file
Select 'edit links'
Select 'break link'
Repeat as needed for all links
Save as new name
Links will be permanently deleted

 

[GrilledCheese]

Works Great. Thank you. For some reason, I tried the same thing prior to posting this thread and it didn't work. But now it works. Strange. But thanks.

Open the file
Select 'edit links'
Select 'break link'
Repeat as needed for all links
Save as new name
Links will be permanently deleted

 

[cyrilbrd]

Works Great. Thank you. For some reason, I tried the same thing prior to posting this thread and it didn't work. But now it works. Strange. But thanks.

No worries, glad you got it sorted out...