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?



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