Can I use mulitiple sheets as a range for a Pivot Table?

  • Thread starter Thread starter Mike Saffer
  • Start date Start date
M

Mike Saffer

Hello,
I am running into a problem with Excel's 65K+ row limit. My database will
soon exceed the limit. When I select a range for a Pivot Table, can I
combine 2 or more sheets as the range and effectively make my database,
let's say 130K+ rows? If so, could you explain to me how to do this?
Best,
Michael Saffer
 
Hi
AFAIK you can have only one Excel range in your pivot table. A
workaround could be the following:
- move your data to a 'real' database (e.g. MS Access)
- You can choose this database as source for your pivot table and
overcome the 65K limit
 
Back
Top