topic Error using MS Excel VBO - Extended::Amend Pivot Table Data Source in Product Forum

Error using MS Excel VBO - Extended::Amend Pivot Table Data Source

amaterano — Tue, 13 Dec 2022 10:52:00 GMT

I have tried in different ways but the error always occurs when trying to update (pivot table and datasource on different sheets as well as on the same sheet)

MS Excel VBO - Extended::Amend Pivot Table Data Source

Internal : Could not execute code stage because exception thrown by code stage

Many thanks in advance

Regards

------------------------------
alirio materano
Consulting
SOAINT
Europe/London
------------------------------

RE: Error using MS Excel VBO - Extended::Amend Pivot Table Data Source

ewilson — Tue, 13 Dec 2022 17:59:00 GMT

Hello @amaterano,

I believe you have the values of Worksheet and Source Data Worksheet backwards. Worksheet should be the name of the worksheet where the PivotTable resides. Source Data Worksheet should be the name of the worksheet that contains the range of data that will feed the PivotTable.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------