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?
|