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,

You may use a different storage for the data. If you have a database
available, put the data in a table there, if not a csv/text file can be also
used as the data origin.
When you create the table, you have to select the "External data source" as
the origin and configure the appropiate connection.

Hope this helps,
Miguel.

"Louise" wrote:

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,