How to refresh a pivot table with new data

[MarkAnderson]

Can anyone help me please.

I have a pivot table that I formatted etc and now want to update the source data. I dont want to create a new pivot on the new data but use the existing pivot table with the new data.

Is there a way I can tell the pivot table which data to now look at ?

Many thanks for any help.

Mark

[Andy Pope]

Select pivot table.

Pivot table tools > Options > Data > Change Source Data.

Use the dialog to expand and or extend the data source range.