Ok, I know this is a very open-ended question but any help will be
greatly appreciated. I am developing workbooks for the current version
of my companies software. We have the ability for users to import
workbooks from previous versions of our software. On computers using
Office 2000 the process takes about 2 minutes which is fine, however on
Office 2003 the process takes up to 15 minutes. I have the task of
improving this perfomance, but am quickly running out of ideas. If
anyone knows of any websites, forums or any source of knowledge that
they would like to share, I would greatly appreciate any help.

I've read reports that XL2000 runs perhaps 30% faster than XL2003 albeit
XL2003 has more capabilities including being able to handle larger
workbooks. But 2 vs 15 minutes seems a lot, maybe something here and related
pages might shed some light -

http://www.decisionmodels.com/calcsecretsd.htm

Regards,
Peter T


"LoDawg" wrote in message
ups.com...
Ok, I know this is a very open-ended question but any help will be
greatly appreciated. I am developing workbooks for the current version
of my companies software. We have the ability for users to import
workbooks from previous versions of our software. On computers using
Office 2000 the process takes about 2 minutes which is fine, however on
Office 2003 the process takes up to 15 minutes. I have the task of
improving this perfomance, but am quickly running out of ideas. If
anyone knows of any websites, forums or any source of knowledge that
they would like to share, I would greatly appreciate any help.

Thanks for the link it does shed some light on the issue for me. And
now time to rewrite some code. If you or anyone out there wants to
share I am still listening. Thanks again Peter