community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx to open existing excel with Pivots and refresh them

Highlighted
Asteroid

Hi there,

 

I am fairly new to Alteryx and in a fix. I have an existing excel file (7 tabs) and pivot tables pointing to one of these tabs. I have updated the data in these tabs through Alteryx. Now, the final goal is to refresh the existing pivot (3 pivots on same tab) through Alteryx.  I read somewhere that it can be done using the RUN command but couldn't find anything to see how to do tihs.

Can someone help me achieve this through Alteryx?

 

TIA.

 

Nebula
Nebula

hi @Bhavika

 

As @BenMoss states in this post, you can create a vbs script to refresh the file after it's written.

 

Dan

Labels