I have data in a spreadsheet in excess of 65536 lines so I have the data on
more than one page in a workbook. How do I create a pivot table that will
use more than one page of data to create the pivot table? Is it possible?