Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2003 Upgrade - statistic function changes?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2003 Upgrade - statistic function changes?
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...b;en-us;828888 In article <Y6vge.10141$Fa1.7183@fed1read02, "Revolvr" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If you have office 2003 and just want to upgrade Excel | Excel Discussion (Misc queries) | |||
Corrupted File during Office 2003 upgrade. | Excel Worksheet Functions | |||
Have to upgrade from office 2000 to 2003, need some help. | Excel Discussion (Misc queries) | |||
Missing Personal.xls in Office 2003 Upgrade | Excel Discussion (Misc queries) | |||
Is it worthwhile to upgrade Office 2000 to Office 2003? | Excel Programming |