Refresh 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.