question

DrX-8354 avatar image
0 Votes"
DrX-8354 asked

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

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-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers