Refresh the data in a PivotTable form
Note A PivotTable form is different from a form that is opened in PivotTable view. You cannot create PivotTable forms in Microsoft Access 2002 or later. Instead, you can open an existing form in PivotTable view and build the layout of the view, or use the PivotTable wizard to help you design the PivotTable view for a new form.
- Open the PivotTable form in Form view.
- Click the Edit PivotTable Object button.
- On the Data menu in Microsoft Excel, click Refresh Data.