Links to workbooks

G

Guest

Several cells within different sheets of a workbook are
linked to cells in other workbooks. How can one readily
break these links, but keep the value shown without also
eliminating the links and/or formulas that exist among
worksheet cells within the same workbook?
 
R

Rita Palazzi

If your data is organized such that entire rows/columns reference the
external data, you can select the row/column, copy/paste special-"Values".
 
Top