Understand how to adjust the absolute, but what if I have my cell by cell
going from A1:J358. Now is someone adds a row to the external sheet say they
add a total or summary starting in A375, how would I know in my Main linked
sheet? Do I need to just have the entire sheet reference the other? If so
how large is that going to make the file and would it ruin performance?

"Dave Peterson" wrote:

You'll need to do it cell by cell.

But once you create the formula for A1 (and change it to relative addressing
(losing the $ signs in the address), you can copy down and copy across.


Steven M. Britton wrote:

I would like to try to link a worksheet or tab in a workbook to an external
excel file. I know that we can link cells that reference other workbooks,
but is it possilbe that just the entire tab could reference another worksheet
from an outside workbook?

-steve

--

Dave Peterson