I have created a pivot table that is linked to an access table. Each month,
the table needs to be updated for the current months data. I've created an
access query to do so, but I'd like the user to be able to run the query from
the Excel file that contains the pivot table.

This query is to be run only once each month, so an "upon open" function
isn't appropriate. I'm leaning toward using a control button.

Can you help?