Slow RowHeight behavior marc.klein[ at ]free.fr 22.08.2006 15:05:47 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

RE: Slow RowHeight behavior Kevin McCartney 22.08.2006 15:30:02 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[ at ]free.fr" wrote: [Quoted Text] > 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 > >

Re: Slow RowHeight behavior marc.klein[ at ]free.fr 22.08.2006 16:28:22 Hi Kevin, Kevin McCartney a écrit : [Quoted Text] > 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