Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 high cpu usage, format cell, wrap text | Excel Discussion (Misc queries) | |||
Excel 2007: Color of high-lighted cells | Excel Discussion (Misc queries) | |||
High CPU in Excel | Excel Discussion (Misc queries) | |||
excel 2003 high cpu | Excel Discussion (Misc queries) | |||
How do I tell Excel that I'm printing a 1" high label | Setting up and Configuration of Excel |