Forum Discussion
PDTaylor
Oct 22, 2021Copper Contributor
Excel Script - Refresh data
Hi, I have an excel file which has a data connection. I have been trying to get the data and associated pivot tables to refresh through a script but it doesn't seem to work fully. The script is ...
petraronald
Aug 02, 2022Microsoft
PDTaylor Currently, pivot table refresh/Power Query refresh is not supported with Office Scripts. If you would like to see this feature in the Office Scripts feature-set, please upvote this request here: Enable Office Scripts to refresh Power Query queries · Community (microsoft.com).
- Klaas LanghoutOct 25, 2022MicrosoftPetra, any other suggestions for how with PowerAutomate/OfficeScripts to 'refresh' a query and pivot table ? Want to get to use PowerAutomate to send the latest info including a refresh.
- BaronK2230Jul 22, 2024Copper Contributor
This link appears to be broken? petraronald