Skip to main content

Refresh Pivot Table

Refreshes a specified pivot table.

Input​

  • Sheet Name: Name of the Excel sheet containing the pivot table to be refreshed
    • Type: System.String
  • Table to Refresh: The name of the pivot table that you want to refresh.
    • Type: System.String
    • Required

Options​

  • Layout: The layout format to apply to the pivot table
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • (null)
      • Compact
      • Tabular
      • Outline

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.