# Limitations

## Content

There are a few known limitations of **Excel for .NET**.

* There is no support for the PivotTable declaration.
* VBA Macro is supported now, but it is limited. **Excel for .NET** only supports opaque copy for Open XML format.
* When saving a formatted cell using the **Fill** property from an .xlsx to an .xls file, an ArgumentException is thrown if the rows and columns in the .xlsx format are more than the maximum for the .xls format.
* A chart object is not saved whenever an Excel file is loaded and saved using **C1.Excel**, irrespective of the file format(BIFF, OpenXml).
* There is no support for the Protect Structure/Windows:
    * When **Excel for .NET** is used to load a Microsoft Excel file that is password protected for Structure/Windows: a "Central dir not found" exception or FileLoadException may occur.
    * The following image shows how a workbook has been password protected for Structure and Windows in Microsoft Excel 2010.