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 |
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 |
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 |
Do you have any updates on this? Have you messaged MSFT?
Quote:
|
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com