M
Michael S. Wall
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?
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?