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
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
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
Recalculate Excel Formulas
Recalculate the workbook's formulas and save. Use after writing values other formulas rely on