How to make excel sharepoint run in the background using automate script?

Question

Hery Cahyadi - DAD 0

I made an auto refresh pivot table, but it only works when Excel in SharePoint is opened (Active), how can I make this run without opening it.

Wamwitha Love 76 Reputation points Microsoft Employee

2023-10-04T23:16:59.0133333+00:00

Depending on your scenario you may be able to leverage Power Automate to achieve your goals. Here is a post that you may find useful: https://powerusers.microsoft.com/t5/Using-Flows/Refresh-excel-pivot-table-from-power-automate-don-t-work/m-p/1462198#M28824.
Wamwitha Love 76 Reputation points Microsoft Employee

2023-10-04T23:18:07.7733333+00:00

Depending on your scenario, you may be able to leverage Power Automate to achieve your goals. Here is a post that may help: https://powerusers.microsoft.com/t5/Using-Flows/Refresh-excel-pivot-table-from-power-automate-don-t-work/m-p/1462198#M28824.

Your answer

Wamwitha Love 76 Reputation points Microsoft Employee

2023-10-04T23:16:59.0133333+00:00

Depending on your scenario you may be able to leverage Power Automate to achieve your goals. Here is a post that you may find useful: https://powerusers.microsoft.com/t5/Using-Flows/Refresh-excel-pivot-table-from-power-automate-don-t-work/m-p/1462198#M28824.
Wamwitha Love 76 Reputation points Microsoft Employee

2023-10-04T23:18:07.7733333+00:00

Depending on your scenario, you may be able to leverage Power Automate to achieve your goals. Here is a post that may help: https://powerusers.microsoft.com/t5/Using-Flows/Refresh-excel-pivot-table-from-power-automate-don-t-work/m-p/1462198#M28824.