Expand the area of a pivot table

[Debbie Uniforms]

Good morning!

I have created a pivot table (round of applause for me please!)

I have added additional columns to the raw data but the data is not showing in the pivot after refreshing.

I believe this is because the initial area of the pivot doesn't include my last column.

Could you tell me how to expand the area of the pivot please?

Many thanks

 

[sandy666]

change raw data to Excel Table (ctrl+T)
add column
refresh PivotTable then go to PivotTable Fields and add your new column to any area