LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
'Step' or Matrix Calculations RBG Excel Discussion (Misc queries) 1 December 24th 08 12:08 AM
Multiple Matrix calculations from data list Gary B Excel Discussion (Misc queries) 11 October 23rd 06 06:43 PM
matrix calculations Jason M Excel Worksheet Functions 2 December 3rd 05 02:47 PM
I'm having a bizzare problem with C&P!!!! Marc New Users to Excel 6 April 24th 05 06:29 PM
MATRIX calculations with VBE Cor Steeghs Excel Programming 1 August 6th 03 01:49 PM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"