Linking Worksheets to different Work Books

K

Kimberly Lay

I am trying to link a worksheet out of one workbook to
another workbook. I want to link the entire worksheet, so
the second file is always updated with the current
information. Is there a way to do this with out having to
put an individual formula in each cell?
 
D

David Hager

You can use Data, Consolidate. However, it does not give you immediate
updates. You will need formulas for that.

David Hager
Excel MVP
 
Top