To refresh a pivot table, select any cell in the pivot table. Click on the 'Analyse' tab in the Ribbon (for Excel 2013 and above) or the 'Options' tab (for Excel 2010 and below). Click on the 'Refresh' button in the 'Data' group.