I have two large spreadsheets in the same file ~ one has the max number of
rows and the other is at 30K rows. The layout of both spreadsheets is the
same. Is it possible to create a single Pivot Table using both spreadsheets
are the data source? I have Excel 2007 if that makes a difference. Thanks
in advance for your help.