I wish I could duplicate this but no dice. Calc mode is manual? Something
is slowing things down. A Google search finds that the question has been
asked before, but not answered.

--
Jim
"Josh Sale" <jsale@tril dot cod wrote in message
...
|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
|
|