How do I link multiple cells from another workbook?

D

Deb T

How do I link multiple cells at the same time, between the source workbook
and the destination workbook? When I select multiple cells at a time, it only
links the first cell in the range.
 
G

Gord Dibben

Copy a range from source workbook.

Switch to destination workbook.

Select a single cell and Edit>Paste Special>Paste Links>OK>Esc


Gord Dibben MS Excel MVP
 
S

ShaneDevenshire

Hi,

And if you are using 2002 or later you can do the copy and in the
destination workbook open the Paste drop down button and choose Paste Links
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How can I change the formula for multiple cells at once? 2
obtaining info from multiple cells from different workbooks. 3
Link To File That No Longer Exists 1
Linking multiple cells between workbooks 2
Hyperlink to cells in other workbooks keep changing 3
Use cell references in external queries 1
Using wild card characters in Find & Replace 6

Top