Issue with Overlapping Pivot Table in Excel Automation

Help Activities
1

I am working on a UiPath automation project that involves processing Excel files with templates in .xlsx and .xlsb formats. During the process of opening the template and pasting the data into pivot table, I encounter the following error:

“This action will overlap the PivotTable “PivotTable2” with data already in the sheet “8. Created by”. Do you want to replace the data?”
This error occurs when I attempt to work with the Excel file in UiPath.

Has anyone experienced a similar issue? How did you go about resolving it? Any guidance or suggestions would be greatly appreciated!

2

@Neeta_Agarwal,

Looks like your file have pivot table and when you update data, this pivot table is being overlap.

Check if manually also getting same issue.

Thanks,
Ashok :slightly_smiling_face:

3

Hi @Neeta_Agarwal

Please check the below thread which is having the solution