Change Pivot Data Source not working properly

[Jsillero (U5013577)]

As far as I know, Change Pivot Data Source should change the range wherein a table extracts information from. I am using the custom range and sheet setter built into UiPath (I have experimented with the regular input method but it still does not work) and I keep getting the same error:

I tried creating a blank excel file with a brand new table and the same error keeps occuring. I have also checked between different computers in my team and the error replicates.

I am using UiPath.Excel.Activities 3.2.1, and excel language is set to Spanish, in case that might matter to UiPath internally.

Here is a screenshot of the activity in question:

Thank you in advance!

[Mir.Jasimuddin]

@Jsillero,

Change Pivot Data Source only works with named Excel tables, not direct ranges.
Convert the range into a table in Excel and reference that table as the new source.

[prashant1603765 (Prashant Kumar)]

Hi @Jsillero

Pivot table work on the table names so specify the table or convert range into table then use like below:

If helpful, mark as solution. Happy automation with UiPath

[Jsillero (U5013577)]

Yes, it was exactly that, thank you.