Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: VBA Script to refresh pivot table
Topic Summary: How to refresh Pivot table with VBA Script
Created On: 07/16/2018 08:55 PM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 07/16/2018 08:55 PM
User is offline View Users Profile Print this message

Author Icon
DrishyaArinari
n00b (>6 posts)

Posts: 1
Joined: 07/16/2018

I tried to refresh pivot table with the following code in VBA

Application.Workbooks.Open("D:\IT_Routines\PivotTables\SalesAnalysis_AU_TLO.xlsx",,,,"ACASales",,,,,,,,,,)
Rem Application.Visible = True
Rem Windows("SalesAnalysis_AU_KAW.xlsx").Activate
Rem Application.ActiveWorkbook.Sheets("SalesAnalysis").Select
Rem Application.ActiveSheet.PivotTables("SalesAnalysis").PivotCache.Refresh
Application.ActiveWorkbook.RefreshAll
Application.ActiveWorkbook.Save()

Always shows error
 07/18/2018 02:55 PM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hello,

Can you provide the error that you are running into?

Does the code work outside of Automate 11 but on the same machine?

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
Statistics
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 1073 guests browsing this forum, which makes a total of 1073 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog