change pivot table in excel for new requirement

**jolinchew** · 08-15-2012, 11:38 PM

previously we generate the pivot table based on excel sheet 1 field A1 to P121,

now we add one more column S,
is it able to change the pivot table based on field A1 to S121? how to do?

if I click the old pivot table, it only allow me to change the field in the summarization.

**FDibbins** · 08-15-2012, 11:52 PM

yes, right-click into the PT, selecj PT wizard, if its not already showing "layout", click on layout...you can change your range there

**jolinchew** · 08-15-2012, 11:57 PM

I'm using the Apple computer, no right click, no mouse, how to

**FDibbins** · 08-16-2012, 12:51 AM

sorry, i use a pc, no idea how to do that on a mac then

**jolinchew** · 08-16-2012, 01:17 AM

Hi, if I click the existing pivot table, it will bring the pivot builder, you can only change row label, column label and value, how can you change the data ranges