ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Office 2003 vs. Office 2000 performance (https://www.excelbanter.com/excel-programming/371049-office-2003-vs-office-2000-performance.html)

LoDawg

Office 2003 vs. Office 2000 performance
 
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.


Peter T

Office 2003 vs. Office 2000 performance
 
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.




LoDawg

Office 2003 vs. Office 2000 performance
 

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



All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com