To add an action to enable once say a new row is added to a table as part of the flow to the have a subsequent action of refreshing all pivot tables / pivot charts.
In addition a further action to refresh all external links to an excel spreadsheet file.
Benefit - auto refresh action to be added as the next step after a table has a new row added or an existing row updated so a related pivot table / pivot chart is refreshed.
Is there a workaround to this now? We can't use macro enabled excel files with flow. How do I do this? I just need the pivot tables updated automatically!
@KProuty Currently .xlsm files cannot be used with Forms / Flows. Fingers crossed this will be sorted.In the meantime if you have a Form and you want to analyse the responses with pivot tables automatically I have a workaround.If you would like to discuss please let me know your LinkedIn profile details and I will connect with you.
Good idea to have the pivot table refresh action add in.
I'm currently stuck at here!!!
Microsoft - pls help!
There is a workaround I have come up with.Create a separate data / pivot table file and then write an auto open macro which when you open the analyser file it opens the linked form file and copies excel table into a sheet in the analyser file and then refreshes pivots. Little bit more involved than this simple explanation but is doable. Use this several times.Hope this helps you.
Yes please, I tried using the script trigger in power automate. But no dice, no error, it looks like it triggers the script fine but it does not actually run it.
In case you are not familiar with the script ability. An xlsx file does not allow macro (VBA) when it is on prem but up in excel (online) you can add VBA script to xlsx files that store in a SharePoint or onedrive. Then, you can trigger that script from power automate. This was my refresh script below.
For those asking for this in Sharepoint, I find if you embed the pivot table or pivot chart in Sharepoint rather than use file viewer, when you open the SharePoint page these do get refreshed automatically.
You must though tick "Refresh data when opening the file" in the data tab within Pivot Options for each pivot table.
Google Sheet doesnt even need a flow. A free service! It would be great if a paid service would perform better in most, if not all, aspects.
Hello @Paulburn !
I am trying to replicate your solution using a conection between the pivot table and a report on salesforce.
But I am having the issue where the script is run without errors but it doesn´t refresh the data.
The link at the first step is broken, I don´t know of the info tht I am missing is there or if there is something else missing in my solution. I tried and followed yours steps with no luck.
And you are the only one around here that manage to get this thing working, so I came for help!!
When I try to refresh the pivot table at the online Excel I get an error. If I refresh the table on the desktop aplication, it works. It think this maybe the issue, but not sure.
Thansk a lot!
Thanks a lot!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.