Macro to update pivot tables AFTER report builder requests have refereshed

andrews89039829

13-12-2017

Hi,

I'm looking for a VBA code that will refresh my pivot tables after my report builder requests have finished refreshing, reason being I need the pivot to amend the data for the front end of the dashboard.

Can anyone help with a link or a code at all to point me in the right direction?

Thanks,

Andy

Accepted Solutions (1)

Accepted Solutions (1)

PratheepArunRaj

Moderator

13-12-2017

Dear Andy,

For security reasons, you cannot schedule a workbook that contains a macro through the report builder scheduling interface.

Thank You!

Arun

Answers (2)

Answers (2)