Macro to update pivot tables AFTER report builder requests have refereshed

[#1]

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

[#2 · 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

[#3]

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

[#4]

Hi Arun,

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

Thanks,

Andy