Hi I am using Excel 2007 and trying to create a dynamic range for a pivot
table so that its source adjusts depending on the number of rows in the
xternal workbook source.

I have created a range "SalesDataset" with the following formula:

=OFFSET(Summary!$A$1,0,0,COUNTA(Summary!$A:$A),COU NTA(Summary!$1:$1))

However when I try to change the Pivot Table data source to =SalesDataset I
get a pop up "Reference not valid"

Can anyone steer me in the right direction.

Many thanks
Simon