Change Pivot Data Source

Points a pivot table at a new source range in Microsoft Excel, refreshes it and saves the workbook. Needs Excel installed.

Behaviour

Risk: Low · Idempotent: Yes · Safe to retry: Yes · Recovery: Replayed after a crash

Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.desktop.changePivotDataSource

Properties#

Input#

Workbook Path#

WorkbookPath · String · Required · Default: Not specified in package metadata

The .xlsx, .xlsm, .xlsb or .xls file. Relative paths resolve against the project folder.

Pivot Table#

PivotTable · String · Required · Default: Not specified in package metadata

The pivot table to change.

Sheet#

Sheet · String · Optional · Default: Not specified in package metadata

The pivot table's sheet. Empty searches every sheet.

Source Sheet#

SourceSheet · String · Required · Default: Sheet1

The sheet holding the new data.

Source Range#

SourceRange · String · Required · Default: Not specified in package metadata

The new data, headers in the first row.

Retry and risk#

This activity is safe to retry: running it again after a transient failure does not repeat a side effect. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.

Every activity also has the engine's common properties: Timeout and Continue On Error.

Related activities#

• Create Pivot Table
• Insert Chart
• Invoke VBA
• Refresh Data
• Run Macro
• Save as PDF

Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Excel Desktop. Keywords: excel, pivot, pivot table, data source, source range, change, desktop.

Properties

Input

Retry and risk

Related activities