Example of consolidating excel workbooks datagridview validating edit
Because these functions are not available in Excel 97-2003, they will return a #NAME?
error instead of the expected results when the workbook is opened in the earlier version of Excel..
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.
In Excel 2007, this exceeds the limit for array elements and might return different results.
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 that exceed the maximum formula length limits of Excel 97-2003, and then make the necessary changes to avoid #VALUE! What it means In Excel 2007 and later, a formula can contain up to 64 levels of nesting, but in Excel 97-2003, the maximum levels of nesting is only 7.One or more functions in this workbook are not available in earlier versions of Excel.When recalculated in earlier versions, these functions will return a #NAME? What it means Excel 2007 and later provide new and renamed functions.