mutiple sheetpivot source

  • Thread starter Thread starter VSS
  • Start date Start date
V

VSS

HI,
how can i have pivot source as mutilpe sheets? As i have my pivot source
data to be more than 65550 rows , which will span acreoss multiple sheets.
Its not multiple consolidation sheet option, as it does not provide
selection of column and row areas.
 
Other than using an external data source, like MS Access, I'm not sure
if you can use greater than 65536 rows.
 
Other than using an external data source, like MS Access, I'm not sure
if you can use greater than 65536 rows.
 
You must log in or register to reply here.

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

Similar Threads

Data Consolidation 1
Large Excel Database. Need Help with reporting. 5
PivotTables with multiple sheets (and more than just multipleconsolidation) 1
Custom Reporting Across Sheets 1
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Pivot Table Help! 1
Importing Excel named ranges using MS Query 3
Pivot Table Jam 1

Back
Top