How do I link multiple cells from another workbook?
 

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.

How do I link multiple cells from another workbook?
 

Copy a range from source workbook.

Switch to destination workbook.

Select a single cell and EditPaste SpecialPaste LinksOKEsc


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 09:50:49 -0700, Deb T <Deb
wrote:

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.

How do I link multiple cells from another workbook?
 

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

--
Thanks,
Shane Devenshire


"Deb T" wrote:

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.