AutoFit Very, Very Slow

[Josh Sale]

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

 

[Jim Rech]

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

 

[Josh Sale]

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]

Sure, please send it to me. Thanks.

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