Updating Pivots in excel

[Pangulia]

Hi, 

I've got a workflow that output 200 individual file. I use an excel template to drop the data into and that template has pivots.

I'm struggling to get the pivots to update. I need the pivots to update once data has been dropped into the file. 

I've tried some VBA code to update the pivots when the file is codes, but it doesn't work when Alteryx create the file and updates the data. 

if I open the created file once Alteryx has created it and close it the VBA codes kicks in and updates the pivots. 

I'm using a output data Tool to drop the data into excel. 

[Luke_C]

Hi @Pangulia 

Just set the file to refresh on open:

[Par_O]

VBA code that executes pivots in Excel is not something I'm familiar with, but I have a question. Do you need the data that you currently write to excel or do you only need the pivoted data? If you only need the pivoted data, have you considered completing the blend and pivot directly in your Alteryx workflow? I don't know the structure of your data but Alteryx has many tools and features that allow you to combine and pivot data to your liking. You can of cause also output your current 200 files along with the pivoted data if you need both data sets.

[Pangulia]

Hi Luke,

Thanks for you response. 

I need the pivots to update once the data is dropped into the file. 

if I do it on open the pivots lose there setting and the pivots won't show the correct data. 

I have around 8 pivots at need updating each having a different filter setting. 

[Luke_C]

Hi @Pangulia 

I've never noticed that behavior. If you're set on VBA you could use the run command tool to execute a vbs script that opens the excel file, runs the macro, saves, and closes the file.