# Calculation Modes

## Content



With Excel, you can specify calculation mode for all formulas in the workbook. To do so, you can use [CalculationMode](/componentone/docs/win/online-excel/) property of the [C1XLBook](/componentone/docs/win/online-excel/) class. The **CalculationMode** property accepts input from the [CalculationMode](/componentone/docs/win/online-excel/) enumeration to set the mode to one of the following values:

| **Enumeration Values** | **Descriptions** |
| --- | --- |
| Auto | Sets automatic calculation mode for all formulas in the workbook. |
| AutoNoTable | Sets automatic no-table calculation mode for all formulas in the workbook. |
| Manual | Sets manual calculation mode for all formulas in the workbook (F9 in MS Excel). |

To set the calculation mode for a workbook in Excel, use the following code. In this example, we set the calculation mode to AutoNoTable for the workbook.

```csharp
//set calculation mode
c1XLBook1.CalculationMode = CalculationMode.AutoNoTable;
```