# Setting Formula Calculation Mode of Workbook in Aspose.Cells

Contents

[
Hide
]
Microsoft Excel allows you to set the formula calculation mode, that is, the way formulas are calculated. There are three possible values:

- Automatic - recalculate whenever something is changed, and every time a workbook is opened.
- Automatic except for data tables - recalculate whenever something is changed, but leaving out data tables.
- Manual - recalculate only when the user explicitly requests it by pressing F9 or CTRL+ALT+F9, or when the workbook is saved.

To set the formula calculation mode in Microsoft Excel:

- Select
**Formulas**and then**Calculation Options**. - Select one of the options.

Aspose.Cells also allows you to set the **Formula Calculation Mode** using FormulaSettings.CalculationMode mode property. You can assign it the CalcModeType enumeration which has one of the following values:

- CalcModeType.Automatic
- CalcModeType.AutomaticExceptTable
- CalcModeType.Manual

The following sample code first creates a workbook, then it sets the formula calculation mode to **Manual** and saves the workbook as output Excel file on disk.

**C#**

```
string FilePath = @"..\..\..\Sample Files\";
string FileName = FilePath + "Setting Formula Calculation Mode.xlsx";
//Create a workbook
Workbook workbook = new Workbook();
//Set the Formula Calculation Mode to Manual
workbook.Settings.FormulaSettings.CalculationMode = CalcModeType.Manual;
//Save the workbook
workbook.Save(FileName, SaveFormat.Xlsx);
```