Macro to update pivot tables AFTER report builder requests have refereshed | Community
Skip to main content
andrews89039829
andrews89039829
December 13, 2017
Solved

Macro to update pivot tables AFTER report builder requests have refereshed

  • December 13, 2017
  • 3 replies
  • 1382 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by PratheepArunRaj

Dear Andy,

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

Thank You!

Arun

3 replies

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
December 14, 2017

Dear Andy,

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

Thank You!

Arun

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
andrews89039829
andrews89039829Author
December 14, 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

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
December 15, 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

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
Terms & ConditionsAccessibility statement

Loading footer...