Excel Pivot Table with Access
 

I have Excel Pivot Tables that link to an access database to pull only
certain info. I would like users to be able to update their individual pivot
table without being able to change the query to include additional
information.

When I disable pivot table use, the pivot table won't update on open.

Thanks for any help.
--
Jack