Refresh Data

Refreshes a workbook's data connections, queries and pivot tables in Microsoft Excel, or one named pivot table, and saves it. 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.refreshData

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 · Optional · Default: Not specified in package metadata

One pivot table to refresh. Empty refreshes every connection, query and pivot table.

Sheet#

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

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

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#

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

Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Excel Desktop. Keywords: excel, refresh, pivot, pivot table, data connection, query, power query, desktop.

Properties

Input

Retry and risk

Related activities