Actually, the formula I am using is : normsinv(rand()), so the slowdown could
be caused by normsinv as well.

"zan" wrote:

I have a spreadsheet in which I do some Monte Carlo simulations and use the
rand() function in around 350000 cells. Before upgrading to excel 2003/SP2,
this sheet would calculate in around 20 seconds. After the "upgrade" it now
runs in around 90 seconds. Is there any way for me to recoup the speed
without going back to the old configuration ? Why the slowdown ?