Help me for cretig a pivot table in excel 2003 with data in multiple worksheets.

[adityabhartia]

I have the three months data in three different sheets. Each month has approx 25000 rows. So I cannot merge all of them in one sheet as in Excel 2003 the maximum limit is only 65000 rows, and all data needs 75000 rows.

lease help me for creating a PIVOT by using data from different sheets.

Aditya

 

[Mavericks334]

Save all the data in one file . CSV. Then in Excel use the queries and pull you data , which you can use to create a pivot. Try the below link to create a query
About using Microsoft Query to retrieve external data - Excel - Office.com