Add in Excel Flow the ability to refresh all pivottables and links in an Excel Spreadsheet file

[MikeHod]

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.

Best regards

Mike H

Mike H

[LyndonL37]

Agreed, 100%. This would help with my automated reporting immensely.

[MikeHod]

Hi LyndonL37

Thank you for your supportive comment.  Please add vote.

Thanks 

Mike H

[rburroughs]

This is exactly what I am looking for.  The question is how many votes does it need to get reviewed and considered?

Robbie B

[MikeHod]

Hi Everyone

As before my suggestion is:
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.

If you like others above expressed they want this please firstly add your vote and secondly comment to support. 

The more votes and comments to quicker this will get raised and fingers crossed implemented.

Keep well Keep Safe 

Best Regards

Mike H

[franklintapia2]

Hi! This feature would be very helpful!

[Kaffee_Krampus]

I would also like to have an ability to refresh pivot tables for my embedded spreadsheets from a Flow. 

[Kaffee_Krampus]

I am for it too!

Since I am using a flow to update my online Excel table, it makes sense to also use flow to push out a pivot table refresh - especially if used with embedded excel spreadsheets!

[jsmith504]

Hi guys,

I would also love this - it would make a lot of my reporting processes completely hands off!