Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - MMULT
Can anyone tell me the new limitations of the MMULT function in Excel 2007
Previously in Excel 2002 and 2003 the limit was 5,461 cells I tried MMULT with 10,530 cells in Excel 2007 and it worked! Even though in the Help of Excel 2007 it still says the limit is 5,461 cells. Obviously the limit has been increased - can anyone tell me the new limit? Thanks Al |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - MMULT
See here for a discussion of limits of XL 2007:
http://blogs.msdn.com/excel/archive/...26/474258.aspx They don't address your question specifically, however, there may be some information there from which you can infer MMULTs limits. Alternatively, you contact the bloggers who maintain the blog at the link above and ask them directly. I've contacted them before with other questions and they have been very responsive. As for the documentation--my guess is that the documentation for XL 2007 is still being finalized and therefore is not too reliable. Dave -- Brevity is the soul of wit. "Al" wrote: Can anyone tell me the new limitations of the MMULT function in Excel 2007 Previously in Excel 2002 and 2003 the limit was 5,461 cells I tried MMULT with 10,530 cells in Excel 2007 and it worked! Even though in the Help of Excel 2007 it still says the limit is 5,461 cells. Obviously the limit has been increased - can anyone tell me the new limit? Thanks Al |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - MMULT
Thanks Dave - I sent an email from that link - I hope it gets some results.
I also hope you are right about Microsoft. Al "Dave F" wrote: See here for a discussion of limits of XL 2007: http://blogs.msdn.com/excel/archive/...26/474258.aspx They don't address your question specifically, however, there may be some information there from which you can infer MMULTs limits. Alternatively, you contact the bloggers who maintain the blog at the link above and ask them directly. I've contacted them before with other questions and they have been very responsive. As for the documentation--my guess is that the documentation for XL 2007 is still being finalized and therefore is not too reliable. Dave -- Brevity is the soul of wit. "Al" wrote: Can anyone tell me the new limitations of the MMULT function in Excel 2007 Previously in Excel 2002 and 2003 the limit was 5,461 cells I tried MMULT with 10,530 cells in Excel 2007 and it worked! Even though in the Help of Excel 2007 it still says the limit is 5,461 cells. Obviously the limit has been increased - can anyone tell me the new limit? Thanks Al |
#4
|
|||
|
|||
Do you have any updates on this? Have you messaged MSFT?
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 Beta-Charting | Charts and Charting in Excel | |||
Weakness in the Drag Function of Excel 2007 (Beta) | Excel Worksheet Functions | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
excel 2007 beta text box printing | Excel Discussion (Misc queries) | |||
Trouble opening large size Excel file 155Mb in Excel 2007 | Excel Discussion (Misc queries) |