Forum Discussion
problem with using MINVERSE function
Just happened that I had the grid set up for an 8x8 matrix inversion on an open workbook!
I use Office 365 so my inverse matrix spilt correctly and I got agreement with your (1,1) cell. I then changed the formula to a CSE array. Did you select the entire 8x8 region, click in the formula bar and commit the formula with Ctrl+Shift+Enter? That worked for me.
Traditional Excel's array handling is about as user-friendly as a cornered rat but still better than absolute/relative/mixed referencing!
I have the same problem with Windows 10 and Basic 2019 365, but I don't understand the answer provided, and I have 365, I think.
The first time it worked on a 3x3 array using MINVERSE(array) with CTRL SHFT Insert.
Then I tried it on a 2x2 array. It entered only the first element in the output array.
I tried copying the same 3x3 array to another location. This time MINVERSE either delivers only one element or produces an error.
In Excel 365 if you use Ctrl+Shift+Enter only first element of the array is returned. Try with simple Enter.
Sorry, but it still shows only the (1,1) entry.
The first time I tried it with the 4x4 array I used CTRL-SHFT-ENTER.
Is it possible that EXCEL only allows you to use it once on each spread sheet?
I erased the output matrix from the 4x4 matrix I had succeeded inverting before and tried again with ENTER : just one entry. The I tried again with CTRL-SHFT-ENTER. Still only one entry. It acts like it only allows you to succeed once!
