How to change the source data for pivot table using Office Scripts?

Dr.X 6 Reputation points
2021-04-13T02:04:58.56+00:00

The source data for the pivot table changes daily. I would like to automate the refresh of pivot table using Office Scripts and Power Automate. Tried recording the change of source data, but code editor shows 'unsupported event'.

So my question is - what is the syntax to change source data for pivot table using Office Scripts?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,370 questions
0 comments No comments
{count} votes