Pivot table issue

[DJ]

if raw data has filled up in one worksheet and need another then how to add this new data in existing pivot table.


I actually have over 80000 records and based on this data I need to prepare a pivot table. I use Excel 2003. Since available rows are 65532, data will not fit in one worksheet so I need to use another worksheet. Please assist me preparing one pivot table use the entire data. Is there any way to do this?

 

[Hui]

DJ

Have a look at http://blog.contextures.com/archives/2010/04/16/how-to-create-an-excel-pivot-table-from-multiple-sheets/

 

[DJ]

Thank you very much Hui for resolving this.