Hi,
Is there a way I can refresh excel pivots once the data tab is loaded with data via alteryx using Python tool?
Hi @Nikita-Puniani
Just want to understand the use case here, is there a reason you can't use the pivot table options to refresh the data when the file is opened?
Hi @Luke_C Thanks for the question.
The excel file has many pivot tabs that are directly connected to the database. The user wants the data to be refreshed in the excel every time a stored proc is run. There are 100+ excel files and it would be cumbersome to open each file, refresh the connections and then send it in email. Any thoughts?
