How do I link multiple cells from another workbook?

  • Thread starter Thread starter Deb T
  • Start date Start date
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.
 
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
 
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
 
Back
Top