Office 2003 Upgrade - statistic function changes?

[Revolvr]

Hi all,

I recently upgraded to Office 2003. I have a rather complex Excel file that
performs a Monte-Carlo analysis. Each trial invokes several statistical
functions to generate random variables based on exponential, normal, and
lognormal distributions.

I discovered after the upgrade that this workbook runs much slower than it
used to, probably 5x slower or more. Which is posing a problem for me. Also
I am a little concerned that the results might be slightly different with
the new version.

So, is there a list available of all of the statistical functions that have
changed in Office 2003? Are there any known performance issues? This would
help me target where I have to optimize the code.

Thanks,

-- Rev

 

[JE McGimpsey]

Many of the statistical functions were updated in XL03 in order to
correct serious shortcomings in previous versions. See



Description of improvements in the statistical functions in Excel
2003 and in Excel 2004 for Mac
http://support.microsoft.com/default.aspx?scid=kb;en-us;828888