Excel 2007 high cpu

[Guest]

I am going to try this question again. I have a user with a spreadsheet that
is 65000 row long and goes out to column R. The data in the spreadsheet is
created from a data connection to an Oracle database. The users wants to
select all of the cells and format the cells to "wrap text". For some
reason, this process sends the cpu to 100% and takes over 10 minutes to
complete. The same spreadsheet in Excel XP took about 20 seconds to complete
the task.

I created a test spreadsheet. I put a long label in cell A1. I copied that
cell out to column R and down 65,000 rows. I then selected the area and
formatted the cells to "wrap text." This took about 15 seconds. What is
the difference between my test spreadsheet and my user's spreadsheet? The
only thing that I can think of is the data connection. I remove the
connection, but that did not resolve this problem.

I am trying to figure out why this user's spreadsheet is sending the CPU
levels to 100% and taking forever to complete in Excel 2007. Any ideas?

 

[Jon Peltier]

What version of Excel did you use for your test?

- Jon

 

[Charles Williams]

Sounds like your user is trying to format 1,000,000 rows rather than 65000:
check how they are doing the selection.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

 

[Guest]

Excel 2007
This was not happening in Excel 2002

What version of Excel did you use for your test?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

 

[Guest]

We were not selecting the entire spreadsheet. We were only highlighting the
area with data.

 

[Jon Peltier]

What was different between your test and the user's situation? Did the test
include the same number of sheets with the same amount of stuff on the other
worksheets? Did the user's workbook come from a previous version of Excel?
Are there differences in the installations?

- Jon