Pivot Tables using Multiple Ranges

actdat

New Member
Joined
Feb 11, 2004
Messages
1
Does anyone know how to create a pivot table using multiple ranges? I have a large amount of data that fills 4 worksheets and has 16 columns. The headers/labels for each column are identical. When I use "Multiple Consolidation Ranges" from the Pivot Table Wizard the field options are not my headers (as would be on a normal Pivot Table), rather the only headings I have available are "Row" and "Column." I need to be able to summarize this massive amount of data and have the options to use only the fields/headers I desire. The data is as consolidates as it is going to get. I guess with this amount of data the drill down function of the pivot table might not work since certain items that are drilled down on might easily take up more than one sheet.

I have tried numerous times to get the multiple consolidation ranges to work and have had no luck. I'm beginning to think that Access might be my last option. I would rather use an Excel Pivot Table. I've talked to others and the word I got from them was that the Multiple Consolidatoin Ranges function does not work. I'm hoping someone here might know how to get it to work.

Thanks!
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

Can you verify that the consolidated ranges of interest are the fields selected for you table. Sounds like you might be looking at a different set of ranges other than those you selected...

plettieri
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,096
Messages
5,768,064
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top