Unlinking workbooks

  • Thread starter Thread starter Lionel Fridjhon
  • Start date Start date
L

Lionel Fridjhon

How can I unlink two workbooks?

Alternatively, how can I copy a section of one workbook
containg formulas, into another workbook so that the
formulas transferred to the target workbook do not have
the link to the source workbook?


Lionel
 
Hi,

You can unlink a work book by selecting Edit> Links and
chose breake links.

You can just select paste special and select values to
remove links while copying in to another sheet.

Abdul Salam
 
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

Error Message - Macro to Unlink MS Queries from Workbook 0
Excel Protection 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
Unwanted workbooks on startup 2
Copy value from changing cells without VBA 1
Scattered array cells copy to scattered array cells another workbook 14
Save As and new workbook new name used in existing code 8

Back
Top