Unlinking workbooks

  • Thread starter Lionel Fridjhon
  • 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
 
A

Abdul Salam

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
 

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

VBA code for pasting links -- modifying RDB code for summary workbook 11
Runtime error 438 1
linking sheets and workbooks 0
Unwanted workbooks on startup 2
Insert a link to a pdf file 1
Ignoring a runtime error 1
Need Help with Macro Security 1
Cell values to an array, then array transpose to another workbook 8

Top