Limits of MINV matrix function

Hi,

Does someone know if there are limits when dealing with matrices? I get a
value error if I try to calculate the inverse of a large matrix (68x68
cells). It works up to 52x52 matrices but fails when the matrix is of size
53x53.

To narrow down the problem I defined an identity matrix of dimension 53x53.
{=MINV(A1:AZ52)} works, {=MINV(A1:BA53)} doesn't whereas MMULT of the
identity matrix itself does, no matter of the size of it's dimensions, e.g.
{=MMULT(A1:BA53;A1:BA53)} works perfectly well.

Any idea welcome.

Regards
KJ

Laurent Longre's MoreFunc.xll includes a MINVERSE.EXT function that will
invert larger matrices.

http://xcell05.free.fr/

Jerry

KJ wrote:

> Hi,
>
> Does someone know if there are limits when dealing with matrices? I get a
> value error if I try to calculate the inverse of a large matrix (68x68
> cells). It works up to 52x52 matrices but fails when the matrix is of size
> 53x53.
>
> To narrow down the problem I defined an identity matrix of dimension 53x53.
> {=MINV(A1:AZ52)} works, {=MINV(A1:BA53)} doesn't whereas MMULT of the
> identity matrix itself does, no matter of the size of it's dimensions, e.g.
> {=MMULT(A1:BA53;A1:BA53)} works perfectly well.
>
> Any idea welcome.
>
> Regards
> KJ

Hi Jerry,

it works perfectly well.

Thanks.
KJ

> Laurent Longre's MoreFunc.xll includes a MINVERSE.EXT function that will
> invert larger matrices.
>
> http://xcell05.free.fr/
>
> Jerry
>