I developed an excel spread sheet for doing Monte-Carlo modeling of
investment portfolios... part of the sheet is an large Array
calculation from a default matrix...

On my PC everything works fine... however my matrix calculation fails
on all other PC's when the Matrix gets to 73x73 items... Microsoft
says that something like 50x50 is the max (KB 166342) for ANY matrix
calculation... others echo this info with slightly larger or smaller
Max sizes...

But I am sitting here looking at one that is 250 x 250 items (I need 4
columns for other calculations). There is nothing special about my PC
it's a P4 933 with 256Meg of ram running NT4(SP6) and Office
'97(SR2a). The only thing I think it could be is that some time over
the last three years I've lucked into a Registry change that allows
this.. (I tend to make lots of changes). But I'm damned if I know
what..

I would very much like to know what I have done to make this work... I
would assume that others would also like a way around this limitation.

Before I call MS Priemier support line
1) Does anyone know what I may have done here?
2) Does anyone think they'll care?

When things don't work that should work I know what to do... But I
hate it when something that shouldn't work does...

something like 50x50 is the max (KB 166342) for ANY matrix
calculation
Limitations you cite have to do with things like MINVERSE (not array
formulas in general). If you are just talking about an array formula, 250 x
250 should not be a problem in XL97. It may be a problem in xl95 or
earlier.

There is no registry setting which changes these limits.

--
Regards,
Tom Ogilvy

"ajames54" wrote in message
om...
I developed an excel spread sheet for doing Monte-Carlo modeling of
investment portfolios... part of the sheet is an large Array
calculation from a default matrix...

On my PC everything works fine... however my matrix calculation fails
on all other PC's when the Matrix gets to 73x73 items... Microsoft
says that something like 50x50 is the max (KB 166342) for ANY matrix
calculation... others echo this info with slightly larger or smaller
Max sizes...

But I am sitting here looking at one that is 250 x 250 items (I need 4
columns for other calculations). There is nothing special about my PC
it's a P4 933 with 256Meg of ram running NT4(SP6) and Office
'97(SR2a). The only thing I think it could be is that some time over
the last three years I've lucked into a Registry change that allows
this.. (I tend to make lots of changes). But I'm damned if I know
what..

I would very much like to know what I have done to make this work... I
would assume that others would also like a way around this limitation.

Before I call MS Priemier support line
1) Does anyone know what I may have done here?
2) Does anyone think they'll care?

When things don't work that should work I know what to do... But I
hate it when something that shouldn't work does...

On Mon, 9 Feb 2004 11:45:19 -0500, "Tom Ogilvy"
made this cogent remark :

something like 50x50 is the max (KB 166342) for ANY matrix
calculation
Limitations you cite have to do with things like MINVERSE (not array
formulas in general). If you are just talking about an array formula, 250 x
250 should not be a problem in XL97. It may be a problem in xl95 or
earlier.

There is no registry setting which changes these limits.


It wouldn't be the first time I've gone down the wrong path...
But for some reason or another every other computer I've tried to run
this on fails at exactly the same size ... I get the #VALUE! error at
73 items or more.

Would you be willing to look at my code?

I thought you said it was a worksheet with a matrix?

you can send me a workbook



--
Regards,
Tom Ogilvy


ajames54 wrote in message
...
On Mon, 9 Feb 2004 11:45:19 -0500, "Tom Ogilvy"
made this cogent remark :

something like 50x50 is the max (KB 166342) for ANY matrix
calculation
Limitations you cite have to do with things like MINVERSE (not array
formulas in general). If you are just talking about an array formula,
250 x
250 should not be a problem in XL97. It may be a problem in xl95 or
earlier.

There is no registry setting which changes these limits.


It wouldn't be the first time I've gone down the wrong path...
But for some reason or another every other computer I've tried to run
this on fails at exactly the same size ... I get the #VALUE! error at
73 items or more.

Would you be willing to look at my code?