Not able to paste Pivot data table to another excel sheet

Help Studio
, , , , , , , ,
1

Hello experts!
I am stuck in between my project. The scenario is: I need to copy Pivot data table from one workbook sheet to another workbook sheet. But the problem is when I paste the pivot data table to another sheet using Alt + Ctrl + v , it only able to paste the text not the pure Pivot data table.

Is there any way to paste the entire Pivot data table, from one workbook to another workbook in excel

2

Hello @Prabin_Chand

Instead of this can you try copy sheet or duplicate sheet activity.

3

not worked for me.

4

Hi ,

Please try this XAML . Copy paste range can be used.
country.xlsx (26.6 KB)
Sequence1.xaml (5.5 KB)

5

@Prabin_Chand Check this attached workflow,
Uipath_CopyPivotToOtherWorkbook.zip (19.7 KB)
Hope this may help you :slight_smile:

6

Thank you everyone, i got my answer using duplicate sheet activity