LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Excel 2007 high cpu

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 high cpu usage, format cell, wrap text Michael S. Wall Excel Discussion (Misc queries) 9 October 16th 09 07:34 PM
Excel 2007: Color of high-lighted cells Henrik Kofoed[_2_] Excel Discussion (Misc queries) 1 May 10th 07 05:29 PM
High CPU in Excel mitch Excel Discussion (Misc queries) 0 June 1st 06 02:47 PM
excel 2003 high cpu mitch Excel Discussion (Misc queries) 3 April 6th 06 11:48 PM
How do I tell Excel that I'm printing a 1" high label Pdude Setting up and Configuration of Excel 1 June 1st 05 05:06 AM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"