mutiple sheetpivot source

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.

VSS wrote:
> 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.

VSS wrote:
> 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.