Refresh Pivot Table Activity
The Refresh Pivot Table activity enables users to update existing pivot tables within Microsoft Excel. This activity ensures that the pivot table reflects the latest data from its source, providing up-to-date analysis.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the Excel application instance to be used. | Required |
| Sheet name | The name of the worksheet containing the pivot table. If not specified, the activity defaults to the first sheet in the workbook. | Optional |
| Pivot name | The specific name of the pivot table to be refreshed within the designated Excel sheet. | Required |
Action Types & Examples
Implementation Examples
Field Setup - Excel name: ${newExcel} - Sheet name: Sheet1 - Pivot name: pivot1
Execution Parameters
Technical Notes
Ensure that the specified Excel file is accessible and not locked by other processes during activity execution. The Excel application must also be installed on the machine where the activity is executed.