Pivot table data source
 

I am using Microsoft Excel 2003 and want to ask if it is possible to use
multiple sheets as a data soruce for a pivot table.

At the moment I have set up multiple pivot tables on 1 worksheet using data
on a single worksheet (sheet1) however the volume of data has now exceed the
limit (think its 65536?) so the remaining information is now on a separate
worksheet (sheet2). Is it possible to use both sheets as a data sources for
the same pivot table?

Thanks,
WA

Pivot table data source
 

Check out Debra Dalgleish's explanation of how to create a pivot table from
multiple consolidation ranges:

http://www.contextures.com/xlPivot08.html

Hope this helps,

Hutch

"FerrariWA" wrote:

I am using Microsoft Excel 2003 and want to ask if it is possible to use
multiple sheets as a data soruce for a pivot table.

At the moment I have set up multiple pivot tables on 1 worksheet using data
on a single worksheet (sheet1) however the volume of data has now exceed the
limit (think its 65536?) so the remaining information is now on a separate
worksheet (sheet2). Is it possible to use both sheets as a data sources for
the same pivot table?

Thanks,
WA