# Compatibility Modes

## Content



Excel lets you specify the version of Microsoft Excel you want your workbooks to be compatible with by using [CompatibilityMode](/componentone/docs/win/online-excel/) property of the C1XLBook class. Setting the **CompatibilityMode** property also determines the limits on the sheet size and number of styles that can be applied on the workbook. This property accepts its input from the [CompatibilityMode](/componentone/docs/win/online-excel/) enumeration which provides the following options:

| **Enumeration Values** | **Descriptions** |
| --- | --- |
| Excel 2003 | Sets the compatibility mode to Excel 2003. This means sheets may have up to 65,536 rows and 256 columns and workbooks may have up to 4050 unique cell styles. |
| Excel 2007 | Sets the compatibility mode to Excel 2007. This means sheets may have up to 1,048,576 rows and 18,278 columns and workbooks may have up to 65,536 unique cell styles. |
| NoLimits | Sets the compatibility mode to NoLimits (no version specified). This means that no size limits are enforced. |

To set compatibility mode in Excel, use the following code. In this example, we set the compatibility mode to NoLimits.

```csharp
//set compatibility mode
c1XLBook1.CompatibilityMode = CompatibilityMode.NoLimits;
```