Pivot table source about to exceed 64K rows

  • Thread starter Thread starter John Foyt
  • Start date Start date
J

John Foyt

I have a pivot table that I use for reconciliation between two data
types in a database - business unit and business category, both set up
to track country but with slightly different uses. Through the first
six months of the fiscal year I'm up to about 50,000 rows. I'd like to
keep the reconciliation set up as is and continue to refresh the pivot
tables with new data each month. Probably next month this data will
exceed 64,000 rows.

Is there a way to get a pivot table to use two tabs of data as its
source? Conceivably I could cut the new months to a new tab. Or if
someone has another suggestion, I'd be glad to hear it.
 
You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

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

If possible, store your data in a database, perhaps using MS Access, and
you'll have more flexibility in creating the pivot table.
 
Back
Top