Auto-Refresh Pivot Table When Source Data Refreshes

Hi Folks,

I've been working with Excel and VBA for some time now, but this is my first post. I have an Excel 2013 Workbook with two Worksheets. WS1 contains a table that is linked via MySQL ODBC. This table is set to refresh every 5 minutes. WS2 contains a pivot table that pulls selected data from the table in WS1 and drives a dashboard. Currently, I'm using an Event "Activate" procedure in WS2 to refresh the pivot table. However, I'd like the pivot table to refresh automatically every time the table data WS1 is refreshed. I've tried replacing the Activate procedure with a "Change" procedure, but just can't seem to get the pivot data to refresh. Any assistance/suggestions would be greatly appreciated.