+ Reply to Thread
Results 1 to 3 of 3

Excel 32 bit Spreadsheets on Excel 64 bit program?

  1. #1
    Forum Contributor
    Join Date
    02-27-2004
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    315

    Excel 32 bit Spreadsheets on Excel 64 bit program?

    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!

  2. #2
    Forum Contributor
    Join Date
    02-27-2004
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    315

    Re: Excel 32 bit Spreadsheets on Excel 64 bit program?

    Okay... I thought I had checked my version of Office and it said 64 bit. I just checked Excel (again?) and it says 32 bit - so that is probably the problem. Now to see how I can install the 64 bit version and see if that fixes the problem.

  3. #3
    Forum Contributor
    Join Date
    02-27-2004
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    315

    Re: Excel 32 bit Spreadsheets on Excel 64 bit program?

    I installed the 64 bit version of Office (and verified it was 64 bit under the Account/About screen) and ran two of my larger spreadsheets again. Both used all 8 processors at 100% but the amount of RAM used was anywhere from 3.33 to 3.78 Gb... not even reaching the 4 Gb.

    So, the question is still valid - is there a way to convert these spreadsheets so they will use more than 4 Gb of RAM?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA-How to program sizing and placing Excel window at the start of the program
    By dr.prakash in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2013, 11:45 PM
  2. Need someone to program / help program a VBA / Excel Macro
    By JoeMcDome in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2013, 04:03 PM
  3. [SOLVED] Can Excel Spreadsheets be saved as Microsoft Works spreadsheets?
    By EXCEL WORKS CONFUSED in forum Excel General
    Replies: 4
    Last Post: 08-18-2006, 06:25 PM
  4. How do I combine data from various Excel spreadsheets into one Excel spreadsheets
    By SouthAfricanStan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2006, 01:10 PM
  5. Replies: 3
    Last Post: 08-15-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1