Skip to main content

Task Office - Excel - Recalculate​

Excel - Recalculate Task window on the File filter tab, with the Location settings for the files to 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).

warning

Each workbook is saved over the original file. Password-protected workbooks are not supported.

Recalculate tab​

Recalculate tab of the Excel - Recalculate Task, with the Recalculate settings and Cell coordinates groups

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.