Excel Memory Needed

Windows Memory and RAM

Your Windows PC has various kinds of memory: physical memory (RAM), Windows virtual memory, Excel useable memory etc.

Ultimately Windows virtual memory is limited by the size of your swap file on your hard disk.
However hard disks are very slow compared to physical memory (RAM), so Windows tries to maintain the things it needs to use in RAM and swaps stuff it doesn’t need right now to the Windows swapfile on disk.

The Excel program itself usually occupies between 8MB and 15 MB of Windows virtual memory.
In addition Excel uses additional Windows virtual memory to store workbook formulae and data etc.

Excel uses its own pools of memory (Excel useable memory) for this workbook data. Unfortunately these memory pools are not in general as large as the Windows memory, and may well be a lot less than the RAM on your PC. Excel 95, Excel 97 and Excel 2000 have a limit for workbook formula memory of about 80 MB, and Excel 2002 has a limit of about 160MB. Excel 2003 has a limit of 1 GB and Excel 2007 has a limit which is controlled by Windows, allowing 2 GB, although differences between Excel 2003 and 2007 mean that you may not be able to use larger workbooks with 2007 than with 2003. Excel 2010 and subsequent versions can be installed in either 32-bit or 64-bit versions. ^4-bit versions have substantially larger memory limits.See Memory Limits for details.

How much RAM do you need?

Paging to your virtual memory swap-file is extremely slow. You need enough physical RAM for the operating system, the Excel program and your workbook(s), and RAM is not expensive.

  • If you have more than very occasional hard disk activity during calculation, you need more RAM.

For Windows 95/98 you need about 24MB for the operating system and 8-24MB for Excel so:

  • 32 MB RAM is OK for small workbooks.
  • 64 MB RAM is OK unless you need to open more than about 32MB of workbooks.
  • 128 MB RAM works well except when using workbooks containing large amounts of data.
  • You will continue to see small speed improvements with 256MB RAM when using large workbooks, particularly with Excel 2002.

For Windows ME and Windows NT you need about 32MB for the operating system and 8-24MB for Excel so:

  • 48 MB RAM is OK for small workbooks.
  • 72 MB RAM is OK unless you need to open more than about 32MB of workbooks.
  • 128 MB RAM is OK except when using workbooks containing large amounts of data.
  • You will continue to see small speed improvements with 256MB RAM when using large workbooks, particularly with Excel 2002.

For Windows 2000 you need about 64MB for the operating system and 8-24MB for Excel so:

  • 72 MB RAM is OK for small workbooks.
  • 128 MB RAM is OK unless you need to open more than about 32MB of workbooks.
  • 196 MB RAM is OK except when using workbooks containing large amounts of data.
  • You will continue to see small speed improvements with 256MB RAM when using large workbooks, particularly with Excel 2002.

For Windows XP you need about 128MB for the operating system and 8-24MB for Excel so:

  • 128 MB RAM is OK for small workbooks.
  • 196 MB RAM is OK unless you need to open more than about 32MB of workbooks.
  • 256 MB RAM works well except when using workbooks containing large amounts of data.
  • You will continue to see small speed improvements with 512MB RAM when using large workbooks, particularly with Excel 2002.
  • Using Excel 2003 with very large workbooks you can make effective use of at least 1GB of RAM.

For Windows 7 and Excel 2010 I would recommend at least 1 GB, and for Windows 10 and Excel 2013 or 2016 2 GB.

How large a Swapfile do you need?

Usually you can let Windows automatically control the size of your swapfile, but if the hard disk containing your Windows system (usually C drive) has very little space you may need to manually control the size and location of your swapfile using the Windows Control Panel (System Properties, Advanced Tab, Performance Settings, Memory Useage). If you work with large workbooks your swapfile should be at least 256MB and preferably 512MB to 1024MB.

You can reduce the amount of swapfile being used by closing programs which are loaded but not in use, and by reducing the number of programs that are loaded at startup.

 

© 2001-2020 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster