Article ID: 313275 - View products that this article applies to.
This article was previously published under Q313275
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.
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.
To work around the source cell limit, follow these steps:
Excel uses internal heap space for different types of operations, including the following:
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.
Article ID: 313275 - Last Review: October 25, 2012 - Revision: 8.0
Contact us for more help
Connect with Answer Desk for expert help.