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

[amaterano]

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
------------------------------

[ewilson]

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
------------------------------