Slow RowHeight behavior

[marc.klein]

Hi,
I have a very strange behavior : on the same computer under windows xp,
with excel 2003, but with two different logins, changing the size of a
cell with the RowHeight property takes either 2-3 seconds or is almost
immediate. The same time is taken when the height of a row is changed
with the mouse. It does not only occur when done by macro.

I checked carefully all the properties of the application object
without finding any differences. I found some reference to a slow
RowHeight behavior on internet, but no real solution.

Has anybody experienced that problem, and found a solution ?

Thanks,
Marc Klein

 

[Guest]

Hi Marc,

Check your desktop properties relating to the screen resolution and color
quality properties. I've had it in the past where some one wanted to select
the entire sheet and it took forever because the machine had little RAM, but
after turning the color quality to low it ran as quick as ever, it could be
somthing similar, but give it a try, it may be that the two user logins have
different screen settings.

HTH and let us know how you get on.

ciao
KM

 

[marc.klein]

Hi Kevin,

Kevin McCartney a écrit :

Check your desktop properties relating to the screen resolution and color
quality properties. I've had it in the past where some one wanted to select
the entire sheet and it took forever because the machine had little RAM, but
after turning the color quality to low it ran as quick as ever, it could be
somthing similar, but give it a try, it may be that the two user logins have
different screen settings.

HTH and let us know how you get on.

Thanks for your tip. In the mean time i found a solution that solves my
problem. I noticed that the problem only occurs on sheets with the page
break displayed. So i add the follwing instructions before the changes
on the row height and auto fits.

ActiveWindow.View = xlNormalView
ActiveWindow.Zoom = 100
ActiveSheet.DisplayPageBreaks = False

After the height changes, I added this instruction to restore the
initial state.

ActiveWindow.View = xlPageBreakPreview


I still do not understand why the problem only occurs on some logins,
but i give up my investigations. In my case, the machine has enough
ram, and the display settings are the same.

Marc Klein