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?

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
_______


"Michael S. Wall" wrote in message
...
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?

Excel 2007
This was not happening in Excel 2002

"Jon Peltier" wrote:

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
_______


"Michael S. Wall" wrote in message
...
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?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Michael S. Wall" wrote in message
...
Excel 2007
This was not happening in Excel 2002

"Jon Peltier" wrote:

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
_______


"Michael S. Wall" wrote in
message
...
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?

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

"Michael S. Wall" wrote in message
...
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?

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


"Charles Williams" wrote:

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

"Michael S. Wall" wrote in message
...
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?