Macro to update pivot tables AFTER report builder requests have refereshed

Avatar

Avatar

andrews89039829

Avatar

andrews89039829

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)

Avatar

Avatar

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

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)

Avatar

Avatar

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

PratheepArunRaj
Moderator

14-12-2017

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

Avatar

Avatar

andrews89039829

Avatar

andrews89039829

andrews89039829

14-12-2017

Hi Arun,

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

Thanks,

Andy