Pivot Table--How can I create from multiple sheets?

[penciline]

Dear Steven:
Thank you very much for your reply and advice.

I am curious now how to create a Pivot Table from multiple sheets. Whenever
I try it fails or doesn't allow me to access the Pivot Table/Pivot Chart
Report menu option. If you or anyone else has any insight on this, please
let me know.

Thanks.

 

[Max]

... how to create a Pivot Table from multiple sheets ..

Perhaps take a look at Debra's page at:
http://www.contextures.com/xlPivot08.html

 

[penciline]

Dear Max:

I am having difficulty with this setup of choosing multiple consolidation
ranges. When I choose a pivot table from a single sheet, it comes out
correct, with the correct column and row categories that I want to pivot.
When I choose multiple consolidation ranges, I only get minimal data
categories. For example, in my snigle-sheet pivot table I have "category"
(art supplies, books, clothing, electronics, etc.) as groups that show how
much I purchased in each group/category. But in the multiple-sheet pivot
table, those categories are missing and I cannot pivot them. I have gone
about the process of selecting ranges exactly the same way in each type of
table, but for some reason the multiple-sheet table is missing this important
data.

Please let me know how I can properly set up my pivot table.

Thanks in advance for your help.

 

[Max]

The limitations you mention are acknowledged in Debra's page under:
"Limitations of Multiple Consolidation Ranges", with some suggested
"work-arounds", eg: to quote: "If possible, move your data to a single
worksheet ... ". Hang around awhile, perhaps Debra herself may pop by here
and offer you more insights ..

P/s: I'm eagerly awaiting Debra's new book:
"Excel PivotTables Recipes"
to reach this part of the world <g> ..