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.