Is there a defined name for the table, something like External_Range1 or
something close to that.

Use that name as the source for you pivot table.

--
Regards,
Tom Ogilvy


"matpj" wrote in
message ...

Hi there,
I have a pivot table on one worksheet, that is refreshed from a range
of data on a second worksheet.

the data is refreshed using a query, so can contain different numbers
of rows.

how can I code it to always refresh using the complete range from the
data worksheet?

can anyone help?


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=477871