On thing you could do is in the vba code turn off autocalculate when you
are doing something then turn it back on when you are finished. I
would also turn it off in general for a workbook that has that much
linked data, that way you can make changes and the workbook won't spend
time calculating cells. When you need to have data updated hit F9 and
everything will calculate. That is one way to help. Unfortunatly with
monte carlo sims they are very very big so it is a resource heavy
program. I have developed some monte carlo sims in the past you can
check them out at www.kjtfs.com. I know some can bog down my 1Ghz
machine, but I also have a 3.6Ghz overclocked machine that handles them
in a snap. :) If your simulation is financial based and isn't
proprietary please email it to me so I can look at it. I always like
looking at new monte carlo methods.

Keith
www.kjtfs.com


---
Message posted from http://www.ExcelForum.com/