you could also define your pivot table data as being from an external
data source .. ie the other spreadsheet which contains the data.
(second radio button in step 1 of 3 in creating the PT).
The additional rows will be automatically included without having to
define a named range.
regards..
--
steven1001
------------------------------------------------------------------------
steven1001's Profile:
http://www.excelforum.com/member.php...o&userid=30757
View this thread:
http://www.excelforum.com/showthread...hreadid=519674