Update the data in a PivotTable form

1. Open the PivotTable form in Form view.
   
   
2. Click the Edit PivotTable Object button.
   
   
3. On the Data menu in Microsoft Excel, click Refresh Data.