Excel 2010. My problem: I’ve got a nicely functioning pivot table; but I’ve been tasked with adding a second source of data. The new data is formatted identically to the original, but for technical reasons it’s not possible to append them in a single block.
It appears that a pivot table can have 2 data sources, and it merges them nicely. But I’d rather not create a new pivot table – I just want to enhance the old one by adding the 2nd source.
Is that possible?
Try this:
Select a cell within your current pivot table, then press ALT+D+P. This will bring up the pivot table wizard. Since the table is already created, the wizard will likely defaut to step 3 of 3. Click the “Back” button twice to get to step 1, which allows you to select the option “Multiple Consolidation Ranges”. Select he ranges and proceed from there.
I don’t have a pivot table/data sources handy that I can walk all the way through the steps above, so I’m not sure what (if anything) it will do to your formatting. It would seem to be worth a try, though.
Thanks, Dr. J.
Weird thing #1: When I press ALT + D + P, Excel echos it back as Alt D D…which doesn’t do anything. However, I was able to add the pivot table wizard to my toolbar, using the toolbar customization feature that lets you put on useful things from previous versions that they inexplicably left off.
Weird thing #2: The wizard does indeed let me back up and add a 2nd data range. Yay. However, when I finish, it clobbers the original pivot table with the new one.
Weird thing #3: the new pivot table is a complete mess – it doesn’t seem to recognize the column headers as such, and thinks things like “Product” and “Month” are instead values of the attribute called “Row”. :rolleyes:
But I’ll keep hacking at it.