ExcelBanter

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

Krandall

Breaking Links
 
I have a worksheet that is a rollup of a number of other workbooks. Each
cell is a formula of links. in other words it adds the cells of 5 other
workbooks. Even though it is set up for 5 other workbooks I don't always use
those other workbooks. I would like to break the link to the workbooks I
don't use. However when i go to EditLinks and select the workbook to break
and click break link it breaks ALL of the links in the formula. How can I
just break one?


All times are GMT +1. The time now is 01:37 AM.

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