Use the 'Nultiple Consolidation Ranges' option when building your Pivot Table.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"djc" wrote:

I have 2 sheet wheet containing 1sheet, 65000 rows and 2nd sheet 45000 rows
with same heading.
Is there a way to run pivot combining 2 seperate sheets? or even on 2
seperate files?