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
 
Top