How can I see how much RAM is available for Excel ?
I am using Excel 2010 Windows (32-bit) NT 6.02 Release:14.0
I know my laptop has 4GB of RAM, but I have been told Excel 32 bit will only be able to use 2GB of this.
31 Answer
Excel 2010, 2013 and 2016 are available in 2 versions: 32-bit (2 Gigabytes of virtual memory)
Out of Memory, Memory Limits, Memory Leaks, Excel will not start.
How can I see how much RAM is available for Excel?
Task Manager will indicate how much memory Excel is using.
On the other hand, the 32-bit edition of Office is limited to 2 GB of virtual address space, and this space is shared by Excel, the workbook, and add-ins that run in the same process. (Worksheets smaller than 2 GB on disk might still contain enough data to occupy 2 GB or more of addressable memory.)
Additionally,
The 2-GB limitation is per windows process instance of Excel. You can run multiple files in one instance. However, if the files are really large and have to be open, consider opening multiple instances for the other files. For information about limits that you may encounter, go to the following website:
Memory usage in the 32-bit edition of Excel 2013 and 2016
Additionally,
32-bit versions of Microsoft Excel 2013 and Excel 2016 can take advantage of Large Address Aware (LAA) functionality after installation of the latest updates. (see the "Resolution" section) This change lets 32-bit installations of Excel 2016 consume double the memory when users work on a 64-bit Windows OS. The system provides this capability by increasing the user mode virtual memory from 2 gigabytes (GB) to 4 GB. This change provides 50 percent more memory (for example, from 2 GB to 3 GB) when users work on a 32-bit system.
Additionally,
If you're running 64-bit Windows, this change is applied automatically. No action by you is required. The available memory for the Excel process is automatically doubled from 2 GB to 4 GB. This improves support for actions that use lots of memory.
