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...