I am using Access 2000. I have created a Pivot Table Form, based on a query, that filters data dependent on the user ID. It works! The data returned to the Pivot Table is the correct data. So the query/filter works. However, when I log in as a different user, the data in the pivot table is unchanged. That is, the data has not been refreshed.
How can I force the data in the pivot table to refresh automatically, when the Pivot Table Form is opened or loaded? If that's not possible, what about refreshing the pivot table data when the 'Edit PivotTable Object' button is clicked?
The Pivot Table options in Excel are set to 'Refresh on open' and NOT 'Save Data with Table Layout'