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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Alteryx to open existing excel with Pivots and refresh them

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.

 

Pulsar

hi @Bhavika

 

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

 

Dan

Labels