Copy pivot and paste to another workbook

I have a pivot like this


I need to:

  1. copy the pivot table only (without the source data) including string at the A1
  2. paste it to another workbook (contain few different existing data) starting from A3 (dynamic).

I tried read range but it’s not working as the pivot cannot be read normally. Most topics in forum suggesting copy sheets but it doesn’t work on me as I need to paste it into a sheet that already have data.


Please try using Get Table Range and pass the pivot table name to this activity it would read whole of the pivot table


To copy a pivot table and paste it into another workbook in UiPath, you can use the following steps:

  1. Open the workbook containing the pivot table you want to copy.
  2. Select the pivot table.
  3. Use the Copy activity to copy the selected pivot table to the clipboard.
  4. Open the destination workbook where you want to paste the pivot table.
  5. Use the Paste activity to paste the pivot table from the clipboard into the destination workbook.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.