1. Microsoft Excel Wont Open Mac Not Enough Memory Drive
2. Microsoft Excel Won Open Mac Not Enough Memory Windows 10
3. Microsoft Excel Won Open Mac Not Enough Memory Windows 7

May 12, 2013 Why do I keep getting 'not enough memory to run Excel' messages? I have a new very powerful computer. Intel Core i7 with an 8mb L3 cache, a 256gb SSD OS drive of which there is 205gb free, two 1TB mechanical hard drives set up in RAID 1, an NVIDIA GeForce GTX 670MX graphics card, and 16gb of 1666mhz ram. Thus, your computer may have enough space in its local memory but excel will show “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space”. Issues like this are basically related to the security settings innate in Excel 2013 or Excel 2016.

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

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:

And Office loves Mac. Office empowers everyone to achieve more on any device. Today, we’re excited to announce that Office 365 is now available on the newly redesigned Mac App Store. We’re committed to delivering the power and simplicity of Office in an experience designed specifically for Mac, and we continue to make significant investments in the platform.

• 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.

Microsoft Excel Wont Open Mac Not Enough Memory Drive

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

Microsoft Excel Won Open Mac Not Enough Memory Windows 10

Excel uses internal heap space for different types of operations, including the following:

Microsoft Excel Won Open Mac Not Enough Memory Windows 7

• 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.