Recalculate the workbook's formulas and save. Use after writing values other formulas rely on
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Full Rebuild fullRebuild | boolean | Optional | true | Recalculate every formula in every open workbook. Turn off to only recompute cells Excel has flagged as dirty. |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Close Excel Workbook
Save and close the Excel file
Convert CSV to Excel
Turn a .csv file into a .xlsx workbook. Quantities become numbers so they will sum, and reference numbers keep their leading zeros
Convert Excel to PDF
Save the workbook, or one sheet, as a PDF
Execute Excel Macro
Run an automated macro inside Excel
Manage Named Ranges
Name a range so formulas can say =SUM(Sales) instead of =SUM(Sheet1!$B$2:$B$500), and keep meaning the right cells when rows are inserted
Refresh Workbook Data
Run every query, connection and PivotTable cache in the workbook again, waiting for the background ones to finish before saving. Needs Windows with Microsoft Excel installed