Excel 2007, 64 bit slower than 32 bit????

[raven_squire]

Hello,

I recently changed from office 32bit to office 64bit as I had hoped that it would bring an increase in performance.

I have one macro that I use regurlarly, it searches through lots of arrays generated from csv data imported to memory.
This macro took two and a half minutes te execute on average with the 32 bit version of excel. It now takes 8 minutes with the 64 bit version.

Can anyone explain why this might be? Is there any way to get the performance increase I was looking for?

 

[Norie]

Can we see the code?

 

[Jaafar Tribak]

Hello,

I recently changed from office 32bit to office 64bit as I had hoped that it would bring an increase in performance.

I have one macro that I use regurlarly, it searches through lots of arrays generated from csv data imported to memory.
This macro took two and a half minutes te execute on average with the 32 bit version of excel. It now takes 8 minutes with the 64 bit version.

Can anyone explain why this might be? Is there any way to get the performance increase I was looking for?

I used to work with 32bit excel and now I have 64bit but I haven't noticed any difference in performance/speed when running macros... but it could be because of the different memory layout and increased size of some data types .

Sorry if my response is rather vague and hasn't been helpful .. maybe someone else can shed a light on this.

 

[raven_squire]

Thank you for the interest. The data that the macro uses and the purpose of the macro is sensitive so I would be in a bit of trouble if I posted it on a forum. I can understand if this makes it hard to give any assistance.

 

[raven_squire]

Jaafar,
Thank you for your input, it does make me wonder if the installation wasn't fantastic given that there would be remenants of the old installation in the registery still. I have been meaning to rebuild the computer and I think it might be a good idea to do it soon.