- Excel 2008 For Mac Keeps Saying Not Enough Memory Upgrade
- Mac Excel Not Enough Memory Error
- Excel 2008 For Mac Keeps Saying Not Enough Memory Foam Mattress
- Dec 26, 2019 Sometimes, the font folder may get damaged; then, you’ll receive the not enough memory/disk space error because the fonts used by the file you’re trying to open are included in that corrupted folder. The easy way to eliminate the error is creating a.bat file that is capable of refreshing your font cache.
- If you are facing a slow Mac performance, or even worse, you often get a notification that “ Your system has run out of application memory ”, then probably your RAM is being used to the max. In this case, you should clear RAM memory on Mac. Read on to learn three ways on how to free up RAM memory on Mac. Clear RAM with Mac Terminal.
- Microsoft Excel users will sometimes get a message that says their computer is out of memory, enough system resources to display completely, cannot complete this task with available resources or Excel can not open workbook with available resources. Excel 2007-2019 users tend to.
My Mac has OS 10.6.8. I have Microsoft Office 2008 installed. Recently, when I try to open Excel, I get the message that there is not enough memory. I deleted a lot of stuff, so now I have 74 GB. Start Excel in safe mode. Safe mode lets you start Excel without encountering certain startup programs. You can open Excel in safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) when you start the program from the command line. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
When you work with a Microsoft Excel file, you receive one of the following messages:
Cause
The above memory error messages can be generic and don't always identify the real cause of the issue. However, if your file is large or contains a large number of features, it is possible you are running low on available memory resources.
Before we explore the more common reasons for the memory errors, it good to understand Excel's limitations. See the following resources for more information:
If you are not hitting a resource limitation, these are the most common resolutions.
Resolution
Follow the provided methods in this article to resolve the available resource error message in Excel. If you have previously tried one of these methods and it did not help, go to another method from this list:
Method 1: Contents of the spreadsheet
The first thing to determine is if the error is specific to one workbook (or others created from the same template). Typical actions that cause memory error messages are:
- Inserting a row or column
- Sorting
- Performing calculations
- Copy and pasting
- Opening or closing the workbook
- Running VBA
If you are seeing the error when performing any of the above actions, it's time to look to determine what is going on in your file. These will be addressed in the sections below.
![Excel 2008 for mac keeps saying not enough memory upgrade Excel 2008 for mac keeps saying not enough memory upgrade](/uploads/1/2/6/4/126456189/999000314.jpg)
Calculations
If you are inserting rows and columns, performing calculations, or copying and pasting and receive the message, it can be tied to formulas having to recalculate.
Consider this scenario:
You have a spreadsheet with 1 million formulas on a sheet and you insert a new column. This will force Excel to recalculate all the formulas in the spreadsheet adjusting for the new column that you inserted. It is possible, depending on the complexity of your spreadsheet, bitness of Excel, and how the spreadsheet is built, and what formulas are used, that you receive the out of resources error.
The following articles address how to optimize performance with calculations:
Other Spreadsheet Elements
Other areas that can cause the memory issues are excess shapes, complex PivotTables, macros, and complex charts with many data points. The following article walks through identifying and fixing these issues.
Custom Views in a Shared Workbook
If you are using the feature Shared Workbook (Review Ribbon > Share Workbook), cleaning out the Custom Views may help with available memory. To do this;
- On the View Ribbon
- Custom Views on the dialog choose Delete
Deleting Custom Views doesn't delete anything in the spreadsheet, it does delete the print areas, and filters. These can easily be reapplied.
If your issue is not resolved after you clean up the file, go to method 2.
Method 2: Verify/install the latest updates
You might have to set Windows Update to automatically download and install recommended updates. Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files and fixing vulnerabilities. To install the latest Office updates, click the link specific to your version of Windows and follow the steps in that article.
Operating system updates:
Office updates:
For more information about Office updates, see Office downloads & updates.
If your issue is not resolved after you install the updates, go to method 3.
Method 3: Add-ins interfering
Check the Add-ins that are running, and try disabling them to see if Excel is working properly. Follow the directions in the following article to disable the add-ins.
If you find that Excel is no longer giving you the error after you remove the add-ins, then it is recommended to contact the manufacturer of the add-in for support.
If your issue is not resolved after you remove the add-ins, go to method 4.
Method 4: Test disabling Preview/Details Pane in Windows 7
If you are running Windows 7, try disabling the preview and details panes in Windows. You will have to disable them in three locations.
Windows Explorer:
- Right click on Start button
- Click Open Windows Explorer
- Click Organize | Layout
- Uncheck Details Pane and Preview Pane
Excel:
- Click File | Open
- Click Organize | Layout
- Uncheck Details Pane and Preview Pane Outlook:
- Open a new e-mail
- In the 'Include' group on the Ribbon, click Attach File
- Click Organize | Layout
- Uncheck Details Pane and Preview Pane
If your issue is not resolved after you turn off preview and details panes, go to method 5.
Method 5: Test a different Default Printer
When Excel launches, it uses the default printer to help render the file. Try testing with the 'Microsoft XPS Document Writer' as the default printer and see if we continue to get the error. To do this;
- Close Excel
- Open the printer and faxes window (XP) or Devices and Printers (Vista, 7, 8, 10)
- Right-click the 'Microsoft XPS Document Writer' printer
- Click Set as Default
If your issue is not resolved after you change your default printer, go to method 6.
Method 6: Test without Antivirus
Antivirus can sometimes cause problems by continuously trying to scan the Excel file or something in the file. Many times the memory error will be random and will be found with any spreadsheet. Test this by shutting off the antivirus temporarily, or by not having Excel files scanned. In some cases, the AV will need to be removed.
If your issue is not resolved after you turn off antivirus, go to method 7.
Method 7: Test with 64-bit version of Excel
Working with large Excel files can use the memory available to the 32-bit Excel application. In any 32-bit application there is a 2-GB limitation.
If your processes need to use more than 2 GB's, then you need to carefully consider moving to Microsoft Excel 64-bit version. The 64-bit version will allow all available physical RAM on the machine to be used. If you are interested in researching 64-bit versions, see 64-bit editions of Office 2013.
If your issue is not resolved after testing on 64 bit, go to method 8.
Method 8: Other applications are consuming the computer's memory and not enough is being allocated to Excel
Does the message clear up for some time after you reboot or shut off some of your applications? That's probably a good sign this is your issue, follow the steps to shut down some of the extra applications running on your computer.
More Information
Additional article
If the information in this article did not help resolve the error in Excel, select one of the following options:
- More Microsoft online articles:Perform a search to find more online articles about this specific error
- Help from the Microsoft Community online:Visit the Microsoft Community and post your question about this error
- Contact Microsoft support:Find the phone number to contact Microsoft Support
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
After you upgrade to Microsoft Office 2013/2016/Office 365, you experience one or more of the following symptoms:
- The computer uses more memory when you open multiple Microsoft Excel 2013 workbooks, save Excel workbooks, or make calculations in Excel workbooks.
- You can no longer open as many Excel workbooks in the same instance as you could before you upgraded to Excel 2013/2016.
- When you insert columns in an Excel workbook, you receive an error about available memory.
- When you are working with an Excel spreadsheet, you receive the following error message:
Cause
Starting in Excel 2013, improvements were made that require more system resources than earlier versions required. This article identifies areas in Excel workbooks that use lots of memory and describes how you can make your workbook files work more efficiently.
For more information about the changes that we made in Excel 2013, see Memory Usage in the 32-bit edition of Excel 2013.
Resolution
To resolve this issue, use the following methods in the order in which they are presented. If the one of these methods does not help, move on to the next method.
Note
Many Excel workbooks have several issues that can problems. After you eliminate these issues, your workbook will run more smoothly.
Formatting considerations
Formatting can cause Excel workbooks to become so large that they do not work correctly. Frequently, Excel hangs or crashes because of formatting issues.
Method 1: Eliminate excessive formatting
Excessive formatting in an Excel workbook can cause the file to grow and can cause poor performance. Formatting would be considered excessive if you formatted whole columns or rows with color or borders. This problem also occurs when formatting requires data to be copied or imported from webpages or databases. To eliminate excess formatting, use the format cleaner add-in that is available in Clean excess cell formatting on a worksheet.
If you continue to experience issues after you eliminate excess formatting, move on to method 2.
Method 2: Remove unused styles
You can use styles to standardize the formats that you use throughout workbooks. When cells are copied from one workbook to another, their styles are also copied. These styles continue to make the file grow and may eventually cause the 'Too many different cell formats' error message in Excel when you save back to older file versions.
Many utilities are available that remove unused styles. As long as you are using an XML-based Excel workbook (that is, an .xlsx file or an. xlsm file), you can use the style cleaner tool. You can find this tool here.
If you continue to experience issues after you remove any unused styles, move on to method 3.
Method 3: Remove shapes
Adding lots of shapes in a spreadsheet also requires lots of memory. A shape is defined as any object that sits on the Excel grid. Some examples are as follows:
- Charts
- Drawing shapes
- Comments
- Clip art
- SmartArt
- Pictures
- WordArt
Frequently, these objects are copied from webpages or other worksheets and are hidden or are sitting on one another. Frequently, the user is unaware that they are present.
To check for shapes, follow these steps:
- On the Home Ribbon, click Find and Select, and then click Selection Pane.
- Click The Shapes on this Sheet. Shapes are displayed in the list.
- Remove any unwanted shapes. (The eye icon indicates whether the shape is visible.)
- Repeat steps 1 through 3 for each worksheet.
If you continue to experience issues after you remove shapes, you should examine considerations that are not related to formatting.
Method 4: Remove conditional formatting
Conditional formatting can cause the file to grow. This occurs when the conditional formatting in the file is corrupted. You can remove the conditional formatting, as a test to see if the problem is with corruption in the formatting. To remove conditional formatting, follow these steps:
- Save a backup of the file.
- On the Home Ribbon, click Conditional Formatting.
- Clear rules from the whole worksheet.
- Follow steps 2 and 3 for each worksheet in the workbook.
- Save the workbook by using a different name.
- See if the problem is resolved.
If removing conditional formatting resolves the issue, you can open the original workbook, remove conditional formatting, and then reapply it.
Problem remains?
If none of these methods work, you may consider moving to a 64-bit version of Excel, breaking your problem workbook into different workbooks, or contacting Support for additional troubleshooting.
Calculation considerations
In addition to formatting, calculations can also cause crashing and hanging in Excel.
Excel 2008 For Mac Keeps Saying Not Enough Memory Upgrade
Method 1: Open the workbook in the latest version of Excel
Opening an Excel workbook for the first time in a new version of Excel may take a long time if the workbook contains lots of calculations. To open the workbook for the first time, Excel has to recalculate the workbook and verify the values in the workbook. For more information, see the following articles:
If the file continues to open slowly after Excel recalculates the file completely and you save the file, move on to method 2.
Method 2: Formulas
Look through your workbook and examine the kinds of formulas that you are using. Some formulas take lots of memory. These include the following array formulas:
- LOOKUP
- INDIRECT
- OFFSETS
- INDEX
- MATCH
It's fine to use them. However, be aware of the ranges that you are referencing.
Formulas that reference whole columns could cause poor performance in .xlsx files. The grid size grew from 65,536 rows to 1,048,576 rows and from 256 (IV) columns to 16,384 (XFD) columns. A popular way to create formulas, although not a best practice, was to reference whole columns. If you were referencing just one column in the old version, you were including only 65,536 cells. In the new version, you're referencing more than 1 million columns.
Assume that you have the following VLOOKUP:
In Excel 2003 and earlier versions, this VLOOKUP was referencing a whole row that included only 655,560 cells (10 columns x 65,536 rows). However, with the new, larger grid, the same formula references almost 10.5 million cells (10 columns x 1,048,576 rows = 10,485,760).
This is fixed in Office 2016/365 version 1708 16.0.8431.2079 and later. For information on how to update Office, please see Install Office updates.
For earlier versions of Office you may need to reconstruct your formulas to reference only those cells that are required for your formulas.
Note
Check your defined names to make sure that you don't have other formulas that reference whole columns or rows.
Note
This scenario will also occur if you use whole rows.
Mac Excel Not Enough Memory Error
If you continue experience issues after you change your formulas to refer only to cells that are being used, move on to method 3.
Method 3: Calculating across workbooks
Limit the formulas that are doing the calculations across workbooks. This is important for two reasons:
- You are trying to open the file over the network.
- Excel is trying to calculate large amounts of data.
Excel 2008 For Mac Keeps Saying Not Enough Memory Foam Mattress
Instead of doing calculations across networks, contain the formula in one workbook, and then create a simple link from one workbook to another.
If you continue to experience the issue after you change your formulas to refer only to cells instead of calculating across workbooks, move on to method 4.
Method 4: Volatile functions
Limit the use of the volatile functions in a workbook. You do not have to have hundreds of cells that use the TODAY or NOW function. If you have to have the current date and time in your spreadsheet, use the function one time, and then reference the function through a defined name of a link.
If you continue to experience the issue after you limit your volatile formulas, move on to method 5.
Method 5: Array formulas
Array formulas are powerful. But they must be used correctly. It is important not to add more cells to your array than you must have. When a cell in your array has a formula that requires calculation, calculation occurs for all cells that are referenced in that formula.
For more information about how arrays work, please see Excel 2010 Performance: Tips for Optimizing Performance Obstructions.
If you continue to experience the issue after you update your array formulas, move on to method 6.
Method 6: Defined names
Defined names are used to reference cells and formulas throughout the workbook to add a 'friendly name' to your formulas. You should check for any defined names that link to other workbooks or temporary Internet files. Typically, these links are unnecessary and slow down the opening of an Excel workbook.
You can use the Name Manager tool to view hidden defined names that you can't see in the Excel interface. This tool enables you to view and delete the defined names that you don't need.
If Excel continues to crash and hang after you remove any unnecessary defined names, move on to method 7.
Method 7: Links and hyperlinks
Excel's power is in its ability to bring in live data from other spreadsheets. Take an inventory of the file and the external files to which it is linking. Excel doesn't have a limit on how many Excel workbooks can be linked, although there are several issues that you can encounter. Test the file without the links to determine whether the issue is in this file or in one of the linked files.
Moving on
These are the most common issues that cause hanging and crashing in Excel. If you are still experiencing crashing and hanging in Excel, you should consider opening a support ticket with Microsoft.
More Information
If none of these methods made a difference, you should consider either moving to a 64-bit version of Excel or breaking your problem workbook into different workbooks.