Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Macro to update pivot tables AFTER report builder requests have refereshed

Avatar

Avatar
Validate 1
Level 1
andrews89039829
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
andrews89039829
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
andrews89039829
Level 1

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
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
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
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
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
Validate 1
Level 1
andrews89039829
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
andrews89039829
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
andrews89039829
Level 1

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