Very poor performance with Excel 2007

[RossR]

I have a workbook that contains about 120 worksheets. It makes heavy use of
VBA through user forms, dynamic web queries, populating worksheets, etc.
There is a summary worksheet that is basically a summary from each of the
individual sheets.

It runs fine under Windows XP and Excel 2003. I have converted two PCs to
Vista and Office 2007. One is a Pentium 4 with 2GB, the other an Intel X64
Core Duo with 2 GB. The workbook opens in roughly 10 seconds. It saves in
from 5 minutes to 8 minutes, depending on machine, environment, etc.

Vista shows it as not responding, but the Task Manager shows the Excel
process at a constant 45-60% CPU usage, less than 50% memory usage for the
duration of the save. It does finally save, and has no error messages.

No viruses are present on either machine. Both machines are completely new
installs, one straight from a vendor, the other complete format and install.
I am not having problems with other workbooks whether running them in
compatibility mode, native 2007 formats, with or without macros.

I have tried the following, and continue to get the same performance:

1) Run it only in compatibility mode.
2) Repaired the workbook during open, converted to the 2007 file format with
macros.
3) Stripped out all but the most minimum set of macros, and saved in 2007
file format with macros.
4) Completely removed all macros and saved in 2007 file format without
macros (the default).

Has anyone experienced similar performance? Does anyone have any suggestion
besides completely re-writing the application?

 

[Dave F]

Two white papers that may have some useful info:
http://technet2.microsoft.com/Offic...168a-42c2-94f5-e5b95a68c54c1033.mspx?mfr=true
and http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Dave

 

[bobcrotch]

I have a workbook that contains about 120 worksheets. It makes heavy use of
VBA through user forms, dynamic web queries, populating worksheets, etc.
There is a summary worksheet that is basically a summary from each of the
individual sheets.

It runs fine under Windows XP andExcel2003. I have converted two PCs to
Vista and Office 2007. One is a Pentium 4 with 2GB, the other an Intel X64
Core Duo with 2 GB. The workbook opens in roughly 10 seconds. It saves in
from 5 minutes to 8 minutes, depending on machine, environment, etc.

Vista shows it as not responding, but the Task Manager shows theExcel
process at a constant 45-60% CPU usage, less than 50% memory usage for the
duration of the save. It does finally save, and has no error messages.

No viruses are present on either machine. Both machines are completely new
installs, one straight from a vendor, the other complete format and install.
I am not having problems with other workbooks whether running them in
compatibility mode, native 2007 formats, with or without macros.

I have tried the following, and continue to get the sameperformance:

1) Run it only in compatibility mode.
2) Repaired the workbook during open, converted to the 2007 file format with
macros.
3) Stripped out all but the most minimum set of macros, and saved in 2007
file format with macros.
4) Completely removed all macros and saved in 2007 file format without
macros (the default).

Has anyone experienced similarperformance? Does anyone have any suggestion
besides completely re-writing the application?

Ross,

I'm having the same problems with some of my users who do lots of data
mining and heavy duty use of excel in general. I'm not an expert on
Excel but this machine should be more than enough to handle what she
is doing.

dual 3.06ghz Xeon processors 2gb of ram running on Windows XP Pro sp2.

She has a complex spreadsheet that is taking anywhere from 5-10
minutes to save depending on the conditions. I cannot find any
information regarding this sort of issue either.

Anyone else having this problem?

 

[Rick]

I had the same problem a few months ago and got no good answers. Went back to
2003 as I couldn't handle the significantly reduced performance.