

With smart fill functionality, you can increment relative references and fill lists. If you are working with several workbooks, try to open them in separate instances of Excel. In Microsoft Office Excel 2003, the limit is increased to 1 gigabyte (GB).īecause this is a per-instance limit, this problem may occur if you have two or three large workbooks open, or one very large workbook. In Excel 2002, the limit is increased to 128 MB. In versions of Excel earlier than Microsoft Excel 2002, the memory limit is 64 MB. to provide copy and paste functionality.The files used are small, typically 50 KB. Sometimes the Excel program will run fine. To increase memory availability, consider:-Using a 64-bit version of Microsoft Excel.-Adding memory to your device. Try using less data or closing other applications. To work around the memory limit, break your work into smaller workbooks, and open them in separate instances of Excel.Įxcel uses internal heap space for different types of operations, including the following: There isnt enough memory to complete this action. Repeat step 2 until you have filled the entire range that you have to fill.Select only the last row or last two rows of the filled range, and then fill farther down the sheet.To do this, click Start, click Run, type taskmgr in the Open box, and then click OK. To determine the amount of available physical memory on the computer, follow these steps: Start the Task Manager tool.

Fill only the part of the range that you have to fill. Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the 'Applies to' section.To work around the source cell limit, follow these steps:

When you copy or fill large sections of a worksheet, one or both of these limitations may affect the result. Each instance is also limited to 32,760 source cells when you perform a smart fill operation.
