In Excel 2007, this exceeds the limit for array elements and might return different results. What it means In Excel 2010 and later, you can use array formulas that contain elements for more than 256 columns and 65,536 rows. Arrays with more than 256 columns or 65536 rows will not be saved and may produce different results. Some formulas contain arrays with more elements than are supported by the selected file format. What to do In the Compatibility Checker, click Find to locate cells that contain array formulas that refer to another worksheet, and then make the necessary changes to avoid #VALUE! errors. Workbook arrays beyond the maximum limit will be converted to and display #VALUE! errors. What it means In Excel 2007 and later, workbook arrays that refer to other worksheets are limited only by available memory, but in Excel 97-2003, worksheets can only contain up to 65,472 workbook arrays that refer to other worksheets. Some of these array formulas will not be saved and will be converted to #VALUE! errors. Some worksheets contain more array formulas that refer to other worksheets than are supported by the selected file format. Issues that cause a minor loss of fidelity Issues that cause a significant loss of functionality Use the new Compatibility Report sheet to work through each issue. Tip: If you have many issues to investigate, select Copy to New Sheet.

Excel 2010 2016 compatibility