CODEWITHSUNDEEP
pivot-tableoffice-jsoffice-addinsexcel-interopexcel-addins
jones-chris
jones-chris

Reputation: 701

Update PivotTable DataSource with the Office Excel JavaScript API

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?

Upvotes: 0

Views: 429

Answers (1)

SiruiMSFT
SiruiMSFT

Reputation: 66

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.

Upvotes: 1

Related Questions