Excel 2016 is not updating calculations

This feature is not supported in Excel 97-2003, and structured references will be converted to cell references.

To avoid errors, you can use those functions instead.

New functions can be replaced with appropriate functions that are available in the earlier versions of Excel.

When the combination of formula arguments (including values, references, and/or names) exceeds the maximum limits of Excel 97-2003, the formulas will result in #VALUE!

errors when you save the workbook to an earlier Excel file format.

What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with more than 40 operands, and then make the necessary changes to avoid #VALUE! Some formulas contain functions with more arguments than are supported by the selected file format.

Formulas with more than 29 arguments to a function will not be saved and will be converted to #VALUE! What it means In Excel 2007 and later, a User-Defined Function (UDF) that you create by using Visual Basic for Applications (VBA) can contain up to 60 arguments, but in Excel 97-2003, the number of arguments in UDFs are limited by VBA to only 29.Some of these array formulas will not be saved and will be converted to #VALUE! 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.Workbook arrays beyond the maximum limit will be converted to and display #VALUE! 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! 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.What it means In Excel 2010 and later, data validation rules can refer to more than 8192 discontinuous areas of cells.In Excel 97-2007, this type of data validation rule is not supported and won't be available.You can also remove formulas that use new functions by replacing them with the formula results.

Tags: , ,