ghisirds Posted December 14, 2008 Share Posted December 14, 2008 Hi all, I had to buy a new laptop because in the old one the Lcd screen get broken. I use it for work so I have bought a very good one, with large screen and high performances, but there is Windows Vista installed (In the old one there was xp). The problem is that if I run the same macro in both the pc the new one is 9 time more slow than the old one: the old pc took 10 second and the new one 90. I have tried with program for benchmark calculation and the new pc has been very fast. I have only got problem with the macro but it simply orders a list with 9000 rows and 8 columns. I have reinstalled office and the sp1 but nothing. The problem is that this excel file will grow up but I can't downgrade to xp for driver and warranty problem. Does anyone know why vista is so slow using the macro and how can I fix it? Thank you very much __________________ You have never see gift ideas like these? (idee regalo on italian) Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/ Share on other sites More sharing options...
frefrefrer Posted December 15, 2008 Share Posted December 15, 2008 which office version are u using ?2003 or 2007 Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/#findComment-998955 Share on other sites More sharing options...
ghisirds Posted December 15, 2008 Author Share Posted December 15, 2008 office 2007 12.0.6214.1000 sp1 mso 12.0.6213.1000 thanks Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/#findComment-999250 Share on other sites More sharing options...
frefrefrer Posted December 15, 2008 Share Posted December 15, 2008 try office 2003 office 2007 12.0.6214.1000 sp1 mso 12.0.6213.1000thanks Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/#findComment-999626 Share on other sites More sharing options...
ghisirds Posted December 15, 2008 Author Share Posted December 15, 2008 missing too many functions that now use ... thanks the same bye Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/#findComment-999640 Share on other sites More sharing options...
ghisirds Posted December 26, 2008 Author Share Posted December 26, 2008 In the same PC with Windows Vista as operating system I have virtually installed Windows Xp using virtual pc. In both the O.S I have installed Office 2007 Sp1. I have copied the same excel file that consist in a long list of phrases inside the cells with a macro that orders it and measure the time that it takes. What do you think it happens? Vista: 25,18 seconds Xp: 1.84 seconds Xp is 14 times faster!!! So, I have done some tests copying only the values or erasing the columns format and I have reached a conclusion: only one column gave me the problem, the column with text on more rows. Erasing only the format of this column the macro execution time pass from 25 seconds to 0.28, almost 100 time faster!!! ("Word wrapping" option the macro slow down a lot but only with Vista operating system) Anyone of you know the reason? Thank you anyway. Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/#findComment-1015108 Share on other sites More sharing options...
donnie1581 Posted December 28, 2008 Share Posted December 28, 2008 In the same PC with Windows Vista as operating system I have virtually installed Windows Xp using virtual pc. In both the O.S I have installed Office 2007 Sp1. I have copied the same excel file that consist in a long list of phrases inside the cells with a macro that orders it and measure the time that it takes. What do you think it happens? Vista: 25,18 seconds Xp: 1.84 seconds Xp is 14 times faster!!! So, I have done some tests copying only the values or erasing the columns format and I have reached a conclusion: only one column gave me the problem, the column with text on more rows. Erasing only the format of this column the macro execution time pass from 25 seconds to 0.28, almost 100 time faster!!! ("Word wrapping" option the macro slow down a lot but only with Vista operating system) Anyone of you know the reason? Thank you anyway. I'm on Vista Home Premium with Office 2007 and I haven't encountered this problem yet. It's quite interesting to hear about it though. I'm going to do some experimenting with the word wrap and running macro's to see what happens. Link to comment https://www.insanelymac.com/forum/topic/140964-vista-problem/#findComment-1017094 Share on other sites More sharing options...
Recommended Posts