Hello,
I'm using Excel 2010. I use dynamically named ranges to grow and shrink as the data grows and shrinks. An example is here:
=OFFSET('All PO''s'!$C$9,0,0,COUNTA('All PO''s'!$C:$C)-3,COUNTA('All PO''s'!$9:$9)-2)
When opening a workbook linking to another workbook with one of these...