Change Pivot Data Source

Estimated reading: 2 minutes

This activity allows users to update or modify the data source of an existing Pivot Table. It is used when the underlying data range, worksheet, or datatable has changed and the Pivot Table needs to reflect the updated source data. It must be used within the Excel Scope activity.

Properties

Input

Source Sheet Name: * Specifies the name of the worksheet where the existing Pivot Table is located. It accepts values of the String data type.

Pivot Table Name: * Specifies the name of the Pivot Table which needs to be updated. It accepts values of the String data type.

New Source Sheet Name: * Specifies the name of the worksheet from which the new data should be fetched to update the existing Pivot Table. It accepts values of the String data type.

Range: * Specifies the data range from the new source sheet to be used for updating the existing Pivot Table. It accepts values of the String data type.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.

Share this Doc

Change Pivot Data Source

Or copy link

CONTENTS