Pivot Table Source Data

G

Guest

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,
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top