Changing Data Source of Pivot table

Help
1

Hi,
I am trying to change the data source for my pivot tables via UiPath but cannot type into the field properly. Everytime I try to type into the field, it adds the range I want to type at the end even though I have empty field marked.
This is the window I am referring to.
image

2

Hi @anon5199880,

Did you get any solution for this?

3

@vinnu.vanga
What I did was use the send hotkey activity to delete the text that is already within the source and then I used the type into activity.

4

I tried the same but didn’t work for me. I got VBA which works perfectly fine.

5

Hi Can you share the VBA code to update the Pivot table data source range
Thank you in advance

6 
Sub Change_Pivot_Source()

    Dim pt As PivotTable

    For Each pt In ActiveWorkbook.Worksheets("Sheet2").PivotTables
             pt.ChangePivotCache ActiveWorkbook.PivotCaches.Create _
                (SourceType:=xlDatabase, SourceData:="Data2")
    Next pt

End Sub

Try above code

1 Like
7

Thank you Vinod
Let me try

I will update the result

Thank you

8

Hi Vinod
What to give My data source range

‘Source worksheet name’! A3:K234

Is this correct?

Please suggest

Thank you in ad

9

Exactly and let me know the result.