Links to workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
If your data is organized such that entire rows/columns reference the
external data, you can select the row/column, copy/paste special-"Values".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Linking workbooks together 1
Paste Values in linked Cells Only 4
Linking blank cells 1
links 1
break link to email workbook 1
break links to other workbooks 4
Trace links between worksheets within one workbook 4

Back
Top