Macro to update pivot tables AFTER report builder requests have refereshed

[andrews89039829]

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

[PratheepArunRaj · Accepted solution]

Dear Andy,

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

Thank You!

Arun

[andrews89039829]

Hi Arun,

Thanks for the reply. Is there any other way for me to auto refresh the pivot in the scheduling process?

Thanks,

Andy

[PratheepArunRaj]

Dear Andy,

Check whether you can duplicate the Pivot using Dynamic Formulas in Excel. We dont have any other option for now!

Thank You!

Arun