Skip to main content
Version: Current

Set Active Worksheet

Description

The Set Active Worksheet activity sets the active worksheet within an Excel workbook.

The active worksheet determines which worksheet is displayed when the workbook is later opened in Microsoft Excel or another compatible spreadsheet application.


Common Capabilities

Process Data Support

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data


Design-Time Configuration

Workbook Configuration

This activity requires an Excel workbook.

Learn more → Excel Workbook Configuration


Worksheet Selection

Selects the worksheet that should become the active worksheet.

Learn more → Excel Worksheet Selection


Behavior

When the workbook is subsequently opened in Excel, the selected worksheet becomes the active worksheet displayed to the user.

This activity does not modify worksheet data, formulas, formatting, charts, comments, or workbook structure.


Outputs

This activity does not produce any activity-specific outputs.


Wait All Incoming

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.

Learn more → Execution Control


On Error

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling