+ Reply to Thread
Results 1 to 2 of 2

LARGEADDRESSAWARE - Excel 2007 from 2 GB Ram TO 4 GB Ram

  1. #1
    Registered User
    Join Date
    03-27-2009
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    1

    LARGEADDRESSAWARE - Excel 2007 from 2 GB Ram TO 4 GB Ram

    Hello,

    I'm italian, I'm working on an univeristy project in financial market and I'm using excel. I'm working on a remarkable amount of data, some spreadsheet has 450 million of cells.

    MY COMPUTER

    CPU Q6700
    RAM 8 GB DDR2
    Graphic card Nvidia GeForce 8800 Ultra

    VISTA 64 Bit
    Office 2007

    I'm looking to increase the use of ram of excel 2007 from 2 GB to 4 GB. I read that it would be possible linking excel with the flag LARGEADDRESSAWARE ... ??

    Anyone could give me detailed information on how to do it (if it's possible)?

    THANKS!!!

  2. #2
    Forum Contributor
    Join Date
    01-18-2005
    Location
    Auckland New Zealand
    MS-Off Ver
    Office Professional 2007
    Posts
    295

    Re: LARGEADDRESSAWARE - Excel 2007 from 2 GB Ram TO 4 GB Ram

    I quote (from http://www.experts-exchange.com/Soft..._23736090.html)

    No process in Windows is assigned more than 2GB of memory unless they have the "IMAGE_FILE_LARGE_ADDRESS_AWARE" flag set in the process header; and 4GB tuning is enabled (the /3GB switch). So Excel's 2GB limit is not unusual. Since Microsoft's documentation indicates 2GB is indeed the process limit for Excel, it's reasonable to assume it is NOT a large address aware application, although that's not explicity stated.

    That doesn't mean you won't benefit from having plenty of memory --> remember that EVERY process is assigned a 2GB user space; and if you have multiple windows open, Excel may/may not have 2GB of "real" memory available. If not, then there will be a lot of paging activity, which can dramatically slow things down. If Excel is the only application you're running, this won't be an issue (as long as you have enough memory for the OS, Excel's core application, and a 2GB recomputation thead (or theads).

    One good thing is that Excel 2007 does make full use of all the cores in your system by running multiple threads during recomputations. This can DRAMATICALLY reduce recomputation times relative to earlier versions.

    I would go with the dual quad-core system you're looking at, and either get XP x32 with 4GB of RAM (if Excel is the only application you'll be running); or get XP x64, and 8GB of RAM. This will both ensure that all of your RAM is available for processes; and will also give you 8 cores for Excel to use in its computations. It will also be enough RAM to ensure that Excel gets a full 2GB of "real" RAM allocated during large spreadsheet computations ... so there won't be any paging delays.

    Unquote

    Also see http://www.decisionmodels.com/memlimitsc.htm for discussion on Excel's memory limits

    Having a dual-core cpu is beneficial.

    Regards
    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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