# 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.