#### Will from London

##### Board Regular

- Joined
- Oct 14, 2004

- Messages
- 217

Hi

I have run exact copies of an Excel file (mainly normal Excel formulae, some custom formulae and a macro that loops by copy/pasting a reference number into one cell, recalculates and then copy/paste special values a single cell result, adds one to the reference number). Calculation is manual.

Anyway running it on the local C:\Temp drives (so network isn't relevant) of each of the following:

PC 1: Intel i3-2120 3.3GHz, 8.00 GB RAM, Windows 64bit (7 Enterprise Service Pack 1), Excel Professional Plus 2013 32bit) it took 7 hours and 46 minutes.

PC 2: Intel i7-6700T 2.8GHz, 8.00 GB RAM, Windows 64bit (7 Enterprise Service Pack 1), Excel Professional Plus 2013 64bit) it took 25 hours and 22 minutes.

I'm sure that the Excel file could be more efficient but can anyone help me understand why the 64bit Excel took over 3 times as long as the 32bit?

EDIT: It saves the file once at the end of the whole process and not during the 7 or 25 hours of calculations.

Any help much appreciated.

Will

I have run exact copies of an Excel file (mainly normal Excel formulae, some custom formulae and a macro that loops by copy/pasting a reference number into one cell, recalculates and then copy/paste special values a single cell result, adds one to the reference number). Calculation is manual.

Anyway running it on the local C:\Temp drives (so network isn't relevant) of each of the following:

PC 1: Intel i3-2120 3.3GHz, 8.00 GB RAM, Windows 64bit (7 Enterprise Service Pack 1), Excel Professional Plus 2013 32bit) it took 7 hours and 46 minutes.

PC 2: Intel i7-6700T 2.8GHz, 8.00 GB RAM, Windows 64bit (7 Enterprise Service Pack 1), Excel Professional Plus 2013 64bit) it took 25 hours and 22 minutes.

I'm sure that the Excel file could be more efficient but can anyone help me understand why the 64bit Excel took over 3 times as long as the 32bit?

EDIT: It saves the file once at the end of the whole process and not during the 7 or 25 hours of calculations.

Any help much appreciated.

Will

Last edited: