You are currently offline, waiting for your internet to reconnect

"Not enough memory" error messages when you copy formulas over large area in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q313275
Symptoms
If you fill or copy formulas into a large area of a worksheet, or you add formulas to a large worksheet, you receive error messages that are similar to the following: 
Not enough memory.
Not enough system resources to display completely.
Cause
Each instance of Microsoft Excel 2007, Excel 2010, and Excel 2013 32-bit is limited to 2 gigabyte (GB) of memory (internal heap space). Each instance is also limited to 32,760 source cells when you perform a smart fill operation. When you copy or fill large sections of a worksheet, one or both of these limitations may affect the result. 
Workaround
To work around the source cell limit, follow these steps:
  1. Fill only the part of the range that you have to fill.
  2. Select only the last row or last two rows of the filled range, and then fill farther down the sheet.
  3. Repeat step 2 until you have filled the entire range that you have to fill.
To work around the memory limit, break your work into smaller workbooks, and open them in separate instances of Excel.
More information
Excel uses internal heap space for different types of operations, including the following:
  • to track cells and formulas.
  • to provide copy and paste functionality.
  • to track pointers to objects.
In versions of Excel earlier than Microsoft Excel 2002, the memory limit is 64 MB. In Excel 2002, the limit is increased to 128 MB. In Microsoft Office Excel 2003, the limit is increased to 1 gigabyte (GB).

Because this is a per-instance limit, this problem may occur if you have two or three large workbooks open, or one very large workbook. If you are working with several workbooks, try to open them in separate instances of Excel.

With smart fill functionality, you can increment relative references and fill lists. By reducing the copy range in any copy or fill operation, you can work around the 32,760 source cell limit. 
XL2003 XL2007 XL2010 XL2013 Excel 2003 Excel2007 Excel2010 Excel2013
Properties

Article ID: 313275 - Last Review: 10/25/2012 16:59:00 - Revision: 8.0

Microsoft Excel 2013, Microsoft Excel 2010, Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft Excel 97 Standard Edition

  • kbformula kberrmsg kbinfo kbbug kbfix KB313275
Feedback
="text/JavaScript" async=""> var varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("