I am using Excel 2003 and am trying to use the multiple sheets function of the Pivot Table (3 of them in one file).

The first sheet has 58616 records
The second has 58917 records
The third has 6921 records

When I attempt to do the pivot, I choose 'Multiple Consolidation Ranges', I then choose 'Create a Single Page Field For Me'. I then choose the 3 sheet ranges and then get an error 'Reference is not valid'.

I am quite familiar with pivots on a single sheet, but I have never done multiple sheets before. What am I doing wrong? Is there a limit to the number that I can bring in? How else could I do this with 120,000+ records?

Any and all assistance is greatly appreciated.

THANKS