Pivot Table in Excel 2007

[Doug Jefferson]

We just started using excel 2007 and I have not been able to figure out how to add an additional column of data to a pivot table without having to delete the table and re-create it. For example let's say that I have 5 col's of data and create a pivot table, then i add 2 more col's of data and want to have the two new col's available in my pivot table.

Thank you in advance for your help.

Doug

 

[ndcam78]

If you right click on any of your fields and go right to the bottom of the menu that pops up (show field list), that brings back your selections so you can add more to your table.

If your using the same lists and adding more to them right click on any field and just hit refresh from the menu.

 

[Doug Jefferson]

I have attempted what you described but it does not appear to work.

Example of Data. (col A - Col E)

A B C D E
ABC 5.00 88 1/1/11 Y
DCF 4.00 66 3/1/11 N
EDF 3.00 77 2/1/11 N



Pivot

I selected col A - Col E for the data. Within the pivot I originally added Col A to the "Rows" and Col B and Col C to the values. Then I realized that I also needed to add 2 more col's to my data

A B C D E F G
ABC 5.00 88 1/1/11 Y 10.00 6/1/11
DCF 4.00 66 3/1/11 N 15.00 6/2/11
EDF 3.00 77 2/1/11 N 7.00 6/1/11

Now I want to bring in col A into "rows" and Col B, C, F, G into the values section of the pivot. My problem is that I do not know how to increase the selection from Col A to Col G?
I am able to add additional col's into the pivot table if they are in the original selection but do not know how to add new col's to the selection once a table is created.


Thank you.

Doug

 

[RoryA]

Select the table, press Alt+DP to bring up the pivot table wizard, then step Back and alter the source range to include the new data (as you would in prior versions).

 

[Doug Jefferson]

Thank you everyone, I am able to add the new col's now.