I want to use the Excel JavaScript API to update an existing PivotTable's data source, which will be a range in another sheet in the same workbook as the pivot table. I've only found documentation that shows how to define a PivotTable's data source when creating a new pivot table, not changing an existing PivotTable's data source.
It was possible to change an existing pivot table's data source when developing an Excel COM add-in and when using VBA, so I'm surprised to not see an example of it in the JavaScript API documentation so far.
Does anyone know how to update a existing PivotTable's data source using the Excel JavaScript API?
Currently, the feature: updating an existing PivotTable's data source, you requested, is not a part of the product. Maybe you can add your request here:Microsoft 365 Developer Platform Ideas Forum.