View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh Sale Josh Sale is offline
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