| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an array size limit for MMULT or MINVERSE in excel 2007?
I have searched MS.com for any clue as whether the array size limit has
improved in the latest version of excel. If it has not changed, I am not going to get it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there an array size limit for MMULT or MINVERSE in excel 2007?
If I'm interpreting this correctly, it appears the limit is the number of
rows in XL 2007, i.e., approx. 1 million: http://support.microsoft.com/default.aspx/kb/166342 Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "jimr315" wrote: I have searched MS.com for any clue as whether the array size limit has improved in the latest version of excel. If it has not changed, I am not going to get it. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there an array size limit for MMULT or MINVERSE in excel 20
The XL 07 developers' blog indicates that array limits are limited by
available memory in XL 07: http://blogs.msdn.com/excel/archive/...26/474258.aspx One of the two links I provided must be accurate. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dave F" wrote: If I'm interpreting this correctly, it appears the limit is the number of rows in XL 2007, i.e., approx. 1 million: http://support.microsoft.com/default.aspx/kb/166342 Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "jimr315" wrote: I have searched MS.com for any clue as whether the array size limit has improved in the latest version of excel. If it has not changed, I am not going to get it. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there an array size limit for MMULT or MINVERSE in excel 2007?
jimr315 wrote:
I have searched MS.com for any clue as whether the array size limit has improved in the latest version of excel. If it has not changed, I am not going to get it. What array size limit for MMULT and MINVERSE are you referring to? Alan Beban |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there an array size limit for MMULT or MINVERSE in excel 2007?
Alan Beban <unavailable wrote...
jimr315 wrote: I have searched MS.com for any clue as whether the array size limit has improved in the latest version of excel. If it has not changed, I am not going to get it. What array size limit for MMULT and MINVERSE are you referring to? Apparently searching through Microsoft's own Knowledge Base doesn't occur to you. Try reading http://support.microsoft.com/kb/166342 and consider not participating in threads for which you're ignorant of the subject matter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Documents | Excel Worksheet Functions | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
| Array | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
