ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Breaking links in Excel (https://www.excelbanter.com/excel-worksheet-functions/235365-breaking-links-excel.html)

brosull

Breaking links in Excel
 
how do I break an excel link to another worksheet when "Break Link" work?

Thanks to Shane for replying.

Benjamin

Breaking links in Excel
 
Does Break Link Work or Not Work? Not sure what you meant exactly.

If you're trying to separate the excel file from it's attached file try this.

Try:
EditLinks
Click Break Link


"brosull" wrote:

how do I break an excel link to another worksheet when "Break Link" work?

Thanks to Shane for replying.


Shane Devenshire[_2_]

Breaking links in Excel
 
Hi,

Your welcome!

You need to be in the file where the link resides not the target file to
which you are linked. The follow Benjamin's suggestion Edit, Links, select
the link and click Break Link. In 2007 the command is Data, Edit Links,...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"brosull" wrote:

how do I break an excel link to another worksheet when "Break Link" work?

Thanks to Shane for replying.



All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com