PDA

View Full Version : Vista problem


Pammachio
12-14-2008, 07:02 PM
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
haapy
12-14-2008, 09:26 PM
How much physical memory do you have? Should be greater than 1GB preferably 2GB or more.
Pammachio
12-15-2008, 12:14 AM
2048mb
meanwhile thanks
bye
Pammachio
12-26-2008, 08:53 PM
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.
soni12
01-15-2010, 10:38 AM
hello i am new here and i want to ask you how perfect is window vista to use for internet please any budy help me
Purchase Domain (http://www.onlinepurchasedomain.com/)