Task Office - Excel - Recalculate

The Excel - Recalculate Task recalculates the formulas in existing Excel workbooks and saves each workbook in place. It cannot refresh data from other data sources; for that, use the Office - Macro Task.
The Main settings, Flow, On error, Conditions and TimeOut tabs are the same for every Task; see Job - Tasks.
The Task settings are on the Excel - Recalculate tab, which has the sub tabs File filter and Recalculate.
File filter tab
The File filter tab selects the workbooks to recalculate; see Task - File filter. The Credential on its Location tab is used to read and save the workbooks.
When no file matches the filter, the Task raises a "file not found" error, which you can handle on the On error tab (see Task - On Error).
Each workbook is saved over the original file. Password-protected workbooks are not supported.
Recalculate tab

Recalculate settings
-
Auto detect: Selected by default; the Task detects the format of each workbook
-
Excel format: When Auto detect is cleared, treats every workbook as "Excel 2007" or "Excel 97 To 2003"
The format decides how the workbook is read and recalculated; the file keeps its format when it is saved.
An Excel 97-2003 workbook is always recalculated as a whole: the worksheet and cell settings below apply only to Excel 2007 and later workbooks.
-
Use workbook: Recalculates every formula in the workbook
-
Use first worksheet: Recalculates the first worksheet
-
Use specific worksheet: Recalculates the worksheet with the name you enter or select
Click Get to list the worksheets of a file found by the File filter tab.
Cell coordinates
Not available with Use workbook. Row and column numbers start at "1", and the fields can contain Variables.
- All cells: Recalculates every cell of the worksheet
- Cell by position: One cell, by Row and Column
- Cells by position range: The cells from Row and Column to End row and End column
- Cell by reference (i.e. A3): One cell, by Cell reference, for example "A3"
- Cell by reference range (i.e. B2): The cells from Cell reference to End cell reference, for example "B2" to "D10"
Output and errors
The output of the Task is the path of each workbook it recalculated, one per line. A workbook that cannot be opened or saved raises an error, and the Task continues with the next file.