Skip to main content

Change Pivot Data Source

Changes the range of the source data for a specified pivot table. You can use this activity if the source range has been modified by adding or removing rows. Or you can select completely different range.

Input​

  • Sheet Name With Pivot Table: Name of the sheet which includes the pivot table to be manipulated
    • Type: System.String
  • Pivot Table Name: The name of the pivot table to be manipulated
    • Type: System.String
    • Required
  • New Source Sheet: The name of the new source page containing the new data.
    • Type: System.String
    • Required
  • New Source Range: The range which contain new data
    • Type: System.String

Details​

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.