---
schema_version: "1"
id: 657068eca9ad4965ffba062598ee71b792924b4ca3347701db8185d04245c452
title: Recalculate Excel File
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/rpa-builder/6.6/toolbox-excel-operations-recalculate-excel-file.md
canonical_url: https://docs.mulesoft.com/rpa-builder/6.6/toolbox-excel-operations-recalculate-excel-file
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 347348581d28bfe3212f7545c53a6a0980138ea6b0d3d85a5888e5a3fb6d0f17
description: MuleSoft Documentation Site
release: "6.6"
latest: false
---
---
product: RPA Builder
version: 6.6
---

# Recalculate Excel File

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

The Recalculate Excel File Action Step can be used to recalculate an Excel sheet. If a value has
subsequently changed, the values in the Excel sheet are updated. To be able to continue working with
the new values, they must be read out again with the _Read from Excel File_ Action Step.

With the Action Step Recalculate Excel File you can determine exactly where a recalculation should
take place in the Workflow.

The recalculation is documented in the Workflow Run Results.

The _Read from Excel File_ Action Step can only be used inside an Excel Session. Specify the source
and destination file in the [Excel Session](https://docs.mulesoft.com/rpa-builder/6.6/toolbox-excel-operations-excel-session).

Please note the operation mode that you have selected in the Excel session:

- **Read and write to the same file** The recalculation is performed on the selected Excel sheet.

- **Read from source and write to different file** The recalculation is only performed in the
  selected destination file.

- **Read only** The Action Step cannot be executed in Read only mode.

## Properties

**Excel Operation Settings**

- **Sheet name** Name of the spreadsheet. In the properties, you can only enter the name directly.
  In the wizard, however, you can select the spreadsheet directly or via the pin variable.

## Inbound Variables

- **Sheet name** Name of the spreadsheet. In the properties, you can only enter the name directly.
  In the wizard, however, you can select the spreadsheet directly or via the pin variable.

**Apply calculation to** Here you specify which part of the Excel file is to be included in the
recalculation.

- **Whole Workbook** (default) The entire workbook is recalculated.

- Or you can select a specific spreadsheet from the list.

## Outbound Variables

The Action Step _Recalculate Excel File_ possesses no outbound variables.
