Description of the limitations for working with arrays in Excel 2000, Excel 2002, and Excel 2003

Check the following link, it provides limitations of using array formulas in Excel.

Description of the limitations for working with arrays in Excel 2000, Excel 2002, and Excel 2003

Note The following are helpful facts to remember about the functions.

? If any cells in an array are empty or contain text, MINVERSE returns the #VALUE! error value.

? MINVERSE also returns the #VALUE! error value if the array does not have an equal number of rows and columns.

? MINVERSE returns the #VALUE! error if the returned array exceeds 52 columns by 52 rows.

? The MMULT function returns #VALUE! if the output exceeds 5460 cells.

? The MDETERM function returns #VALUE! if the returned array is larger than 73 rows by 73 columns.

Related posts:

1. VBA Samples for Working with Excel 2003 Worksheets
2. Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
3. Save HTML files from one folder to Excel files in another folder
4. Importing IE bookmark