Excel 2007 is limited to 2 Gigabytes of memory for the Excel process under Windows XP/Vista (Windows memory limit). This 2 Gigabyte limit is a limit on the Virtual Memory address space. Virtual memory used by a process is larger than the working set memory reported by Windows Task Manager, so the amount of useable memory under Excel 2007 is considerably less than twice that of Excel 2003. Because Excel 2007 (Excel12) also requires more memory to store the indexes to the increased number of rows and columns you may not be able to load larger workbooks under Excel 2007 than was possible under Excel 2003. Memory Fragmentation may also mean that it is difficult to make use of all of the available 2 GB of virtual memory.
Many of the individual memory limits listed below have been removed in Excel 2007.
Excel 2010 is available in 2 versions: 32-bit (2 Gigabytes of virtual memory) and 64-bit (8-Terabytes (which is 8000 Gigabytes of virtual memory)). The 32-bit version has the same memory limits as Excel 2007, but the 64-bit version, when used with a 64-bit Windows operating system, will have extremely large memory limits. Note that the different versions of Windows Vista 64-bit and Windows 7 64-bit support differing amounts of RAM.
670 questions posted
Usually answered in minutes!
43 Questions
22 Questions
12 Questions
2 Questions