View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
John Austin[_6_] John Austin[_6_] is offline
external usenet poster
 
Posts: 18
Default Automation performance degradation in Excel 2007

Dear Jialiang,

I now have another problem. When I first tried my application with
Vista/Excel 2007, I had terrible performance with the first worksheet in the
workbook - it was taking several minutes to produce instead of maybe 15
seconds. The problem then disappeared and the system has been running well.
Today the original problem has re-appeared (following a reboot) and I am back
to taking several minutes to create the sheet. I really need to resolve this
issue as I need to demonstrate the system to prospective customers.

Best regards,
--
John Austin


"Jialiang Ge [MSFT]" wrote:

Hello John,

Would you let me know if the excel file contains some charts created by the
input data? Is there any formula column? Office 2007 SP1 has fixed some
performance issues when a workbook contains some charts created by a large
amount of data in a worksheet. Therefore, my suggestion is to install the
Office 2007 SP1:
http://www.microsoft.com/downloads/d...594-992C-4165-
A997-25DA01F388F5&displaylang=en and see if it has some improvements in
performance of your automation client.

Some members from Excel product team told me that they are still doing
their best to improve the overall performance of Excel 2007. It is slower
than previous version mainly because of its new "big grid" and features.

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.