Updating Pivot Tables

[collinsc]

Right great... I have created some Pivot Tables... However some data has nowc hanged from the original data. Is there a quick way i can update the pivot table to represent the new data?
Or must i delete the pivot table, reselect the data and create it again?

advice appreciated.

Thanks.

 

[colinitaylor]

If you right click on the table, you should see a refresh data option?

 

[collinsc]

Brilliant!

Thanks