You’re offline. This is a read only version of the page.
58
Hi, We have a SharePoint excel file in which some new data goes each day in Sheet1. In Sheet2 of same file, we have a pivot which I want to refresh.
Is there a way to automate 'Refresh all' with Power Automate on excel placed in a SharePoint folder.
If not power automate any other idea to refresh the pivot so it starts reflecting the updated data. Data in sheet1 is present as Table so we are good with reference data range of Pivot as rows increases.
Hi @mayankgoyal
While you take a look at the two links in my post above, I found a post that has an OfficeScript to refresh all pivot tables.
Check the post from @paulburnett224 that has 6 points here.
The code is in point #4.
Hi @mayankgoyal
Consider writing an OfficeScript within excel online and then calling it from Power Automate
https://docs.microsoft.com/en-us/office/dev/scripts/tutorials/excel-power-automate-trigger
You wont need all of the code from the above link.
Recording capabilities of Office Scripts are shown here.
Unfortunately, as far as I know there is no such feature available in Power Automate that can enable you to do this task. But can try configuring auto refresh directly from the excel file in many different ways.
Here's a link to the document that explains more - https://www.techrepublic.com/article/4-tips-for-refreshing-excel-pivottable-objects/
You can also upvote the idea for adding an auto refresh option for excel files from Power automate here - https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Add-in-Excel-Flow-the-ability-to-refresh-all-pivottables-and/idi-p/392897/page/2
------------------------------------------------------------------------------------------------------------------------------
If the information shared helps you, please consider giving a thumbs up and mark solution as resolved
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
