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.

Hi XLINT and welcome to the forum,

I assume you have your Activate code behind the worksheet (WS2) and not in a module. If you do, it will fire (refresh the PT) when you select the worksheet WS2 from another worksheet. If you have the code behind a Change Event it will refresh whenever you change something on the WS2 sheet.

How about putting a button on WS2 that will RefreshAll? Then you will click that and it will refresh.