Pivot Table Data source

S

Shashi Bhosale

I have a Excel Workbook with 3 Worksheet having Sales Data (same format).
The reason i created 3 worksheets is because of the limit of 65K rows /
sheet. I have about 60K records per worksheet.
How i can create a pivot table for the data of all these three sheets ?

Thanks in advance.
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Macro to update pivot table data range 3
Cell data entering slow! 0
Pivot Table Question 2
Adjust Pivot Table Filter based on a Range 0
Changing pivot table ADO recordset 0
Change report firlds in pivot tables and charts with one selection 0
Used Range and Source data of a Pivot Table 1

Top