Read range from PivotTable issue

[omar_ismail]

Hi Team,

i got the below issue what should i do to repiar it

[Baskar_Gurumoorthy]

Hi @omar_ismail

instead reading the pivot table from read range. can you please try with invoke vba code as below.

Read Pivot table source data

Solution: Sub GetPivotSourceData() Dim PT As PivotTable Set PT = ActiveSheet.PivotTables(1) PT.TableRange1.Cells(pT.TableRange1.Rows.Count, pT.TableRange1.Columns.Count).Select Selection.ShowDetail = True ActiveSheet.Name = "READ THIS SHEET" End Sub (Use the above in a Invoke VBA activity) The above expands the data in the pivot table saves it to a new sheet called “READ THIS SHEET” you can then use a read range for this created sheet. If you want to do this more than onc…

you can refer the below video if you are not aware about invoke vba.

UiPath | INVOKE VBA | Invoke VBA Full Tutorial | Difference between Invoke VBA and Execute Macro

hope it helps!!!

hope it helps!!!

[AJ_Ask]

Everthing looks correct. Can you check the is it in the correct Excel Scope. & Name of your Pivot table is correct or not. If not try to put the read range in the separate Excel process scope.