Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bizzare issue with matrix calculations
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'Step' or Matrix Calculations | Excel Discussion (Misc queries) | |||
Multiple Matrix calculations from data list | Excel Discussion (Misc queries) | |||
matrix calculations | Excel Worksheet Functions | |||
I'm having a bizzare problem with C&P!!!! | New Users to Excel | |||
MATRIX calculations with VBE | Excel Programming |