How do I link multiple cells at the same time?

J

Juippi

I need to link a whole table to a different workbook.
How do I do it so that I don't have to link the cells one by one.
I'm using version 2003.
 
B

Bernie Deitrick

Juippi,

Either copy and pastespecial links, or create a link yourself and then copy
it (but first make sure that you turn off the absolute addressing).

HTH,
Bernie
MS Excel MVP
 
Top