mutiple sheetpivot source

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.
 
N

nofliesonyou

Other than using an external data source, like MS Access, I'm not sure
if you can use greater than 65536 rows.
 
N

nofliesonyou

Other than using an external data source, like MS Access, I'm not sure
if you can use greater than 65536 rows.
 
Top