Activities
latest
false
Banner background image
Productivity Activities
Last updated Mar 27, 2024

Refresh Pivot Table

UiPath.Excel.Activities.Business.RefreshPivotTableX

Updates the data for a pivot table. Use this activity when the source data for a pivot table has changed. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity
  • Pivot table to refresh - The pivot table whose data to update.
    • To refresh a specific pivot table, select it using the Plus docs image menu.
    • To refresh all the pivot tables in a workbook, select the Excel file from the Plus docs image menu, and then select All Pivot Tables.
Properties Panel

Common

  • DisplayName - The name displayed for the activity in the Designer panel.

Input

  • Layout - Enhances the pivot table layout and format. The compact form optimizes for readability while the tabular and outline forms include file headers. The default value is null.
  • See Pivot table to refresh in the body of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.