Hi,

I need to create a pivot table using a long list of data which unfortunately
spills over 65536 rows, therefore I have had to create the data source on two
worksheets. Is someone able to tell me whether I can create a pivot table
using data on two worksheets to combine into one pivot table?

I have tried when selecting the source range to try and select Sheet 1 info
and then select data from Sheet 2 also but it won't let me?

Any ideas?

Thanks,