ExcelBanter - AutoFit Very, Very Slow

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - AutoFit Very, Very Slow (https://www.excelbanter.com/excel-programming/361743-autofit-very-very-slow.html)

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

AutoFit Very, Very Slow

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
|
|

AutoFit Very, Very Slow

The workbook doesn't even have a formula in it. If you want, I could send
you the workbook.

I submitted the problem to MS this afternoon and the tech support guy was
able to immediately duplicate the problem. Hopefully they'll have something
to say in the next few days.

josh

"Jim Rech" wrote in message
...
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
|
|

AutoFit Very, Very Slow