LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Automation performance degradation in Excel 2007

I have a VB6 app that creates about 100 populated Excel spreadsheets. I have
installed Office 2007 and the performance of the application has degraded
significantly.

On the same PC, extracting data from the same database, the creation process
takes 50 seconds with Office 2003, but 165 seconds with Excel 2007.

What is happening here? Why is Excel 2007 so slow? The application creates
several hundred of these spreadsheets each week and takes over an hour to
complete with Excel 2003. If Excel 2007 were used it would take all day!

--
John Austin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I improve the 2007 Excel performance. Pete Excel Discussion (Misc queries) 1 April 26th 08 06:43 PM
Degradation of performance : upgrading from Excel 2000 to Excel 20 ecanet Excel Programming 17 May 28th 07 03:06 AM
Degradation of performance when upgrading from Ecel 2000 to Excel ecanet Excel Discussion (Misc queries) 2 May 25th 07 04:20 PM
Temp files causing performance degradation FrankB Excel Discussion (Misc queries) 4 October 31st 05 11:19 PM
Excel Automation - Chart Performance Matt Tessar Excel Programming 4 August 28th 03 08:53 PM


All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"