Hi Air_Cooled_Nut,

Well, 'capturing' this slowly growing Edb is
easy using a named dynamic range:
INSERT / NAME / DEFINE...
our standard name for this is "dynamic"
=OFFSET('sheetname'!$A$1,0,0,COUNTA('sheetname'!$A :$A),COUNTA('sheetname'!$1:$1))

No problem, works fine. EXCEPT you can't use a dynamicly named range
as input for importing external data into a pivot table. When you
eventually get to the "Select Table" dialog box you will not see the
named dynamic range as a choice. What to do?

You could always just type in the name when asked for the source range:

Book1.xls!dynamic

Works for me! And within the workbook, you can just type the name dynamic, or press
F3 to see it listed.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk