I have several (around 20) spreadsheets that I have created on my work computer (i3 2120 3.3Ghz, 4Gb RAM, Win 7 Enterprise 32 bit, Excel 2010 - 32 bit) that I have started to use on my home computer (i7 4790 3.6 Ghz, 16 Gb RAM, Win 7 Home Premium 64 bit, Excel 2013 - 64 bit). The spreadsheets are huge (some as large 50 Mb) with many thousands of calculations.
On my work computer, a couple of the spreadsheets take over an hour to finish calculating and on my home computer the same sheets take about 15 minutes. I know this is because Excel is using all 8 processors on my i7 and only 4 processors on my i3. I was hoping that with my 16Gb of RAM, though, that Excel would use more than 4 Gb of it to calculate the spreadsheets but it's not (and thus complete the calculations even faster).
I have done some Google searches and some say that the spreadsheets created on the 32 bit version of Excel will only use up to 4 Gb, regardless if you have a 64 bit version of Excel installed. If this is so, is there a way to convert my 32 bit spreadsheets to 64 bit spreadsheets so they will use more than 4 Mb of RAM to calculate? Recreating the spreadsheets from scratch is not an option, they are just too big.
Ideas or suggestions?
Thank you in advance!
Bookmarks