Updating Pivot Tables

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
230
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,114,415
Messages
5,547,808
Members
410,813
Latest member
Vhinzvirgo
Top