LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 177
Default AutoFit Very, Very Slow

I had previously described a problem where I thought that
EntireColumn.AutoFit was going into a loop. However upon further
investigation, I found that given enough time, the AutoFit will eventually
finish.

Here's the scoop:

- I have a worksheet that has a little over 35,500 rows in it.

- If I try to AutoFit column C it takes about 1:45 on a very fast (i.e.,
3.2ghz) system.

- If I delete the first row of worksheet and do the AutoFit it completes in
about 1 second.

- There is nothing special about the first row. In fact cell C1 has nothing
in it.

- If I select cells C2:C100 and do the AutoFit (without deleting the first
row) it completes in about 4 seconds (4x as long as AutoFitting the whole
column once I delete the first row).

I've reproduced these results in Excel 97 - Excel 2003.

Any suggestions?

TIA,

josh


 
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
Autofit (Columns.EntireColumn.AutoFit) does not work Michiel via OfficeKB.com Excel Discussion (Misc queries) 3 February 10th 09 05:29 PM
Slow Excel Navigation with Up / Down Arrow and slow scrolling deddog Excel Discussion (Misc queries) 0 August 14th 07 09:56 PM
autofit does not autofit rreneerob Excel Discussion (Misc queries) 1 October 17th 05 05:55 PM
EntireColumn.AutoFit - Slow on Large Files??? Steven M. Britton[_2_] Excel Programming 3 June 9th 05 08:14 PM
row autofit Robin Hammond Excel Programming 0 September 6th 03 02:33 AM


All times are GMT +1. The time now is 04:13 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"