Excel 2008 For Mac Keeps Saying Not Enough Memory

Error There is not enough space available on the disk (s) to complete this operation can be caused by different reasons. You may get this error when trying to use Disk Management to shrink the volume, create a partition or format the disk. To fix the error, you can try all the methods below until you find the one that works for you.

We’ve put together five methods below to fix the error. You may not have to try them all; just work your way down the list until you find the one that works for you.

Note: Solution 4 works only if you get the error when trying to shrink the volume with Disk Manager. If this is not your case, you can skip Solution 4.

Excel 2008 For Mac Keeps Saying Not Enough Memor. Excel keeps saying not enough memory. I will show you How to fix Microsoft Excel cannot open or save any more documents because there is not enough available memory error using 2 simple methods/t.

Solution 1: Complete the operation with a partition manager software

This error is one of the common errors occurring to Disk Management. One situation is you don’t have enough space to complete the operation. The other situation is you have a lot of free space but still get prompt saying not enough space on disk. We recommend using a partition manager software to complete the operation instead of using Disk Management. You won’t get errors when using a partition manager software to shrink the volume or create a partition, as it will fix the errors automatically.

You can search a reputable partition manager software online. If you’re not sure what product you can trust, we recommend using Acronis Disk Director. Acronis Disk Director is a known partition manager software around the world. You can use it to manage the disk status easily without losing any data, like resize the volume, format the disk, etc.

Here’s how to use Acronis Disk Director:

1. Download Acronis Disk Director Freeand install it on your computer.

2. Launch Acronis Disk Director.

3. Select the operation you want to do.
For example, if you want to shrink the volume, select Resize volume in the left pane, then follow the on-screen instructions to complete the operation.

The Free version has limited functions. If you want the full functions, you can upgrade the program to the Pro version.

If you want to fix the error manually, you can try other methods below.

Solution 2: Free up the space

If your disk doesn’t have enough space, you’ll get There is not enough space available on the disk (s)to complete this operation. In this case, you can free up the disk space to fix the error. To learn how to free up space, you can visit How to free up drive space on your PC.

Solution 3: Rescan the disk

To fix error There is not enough space available on the disk (s)to complete this operation, you can reload the partition and volume by rescanning the disk.

You can follow these steps to rescan the disk.

  1. Open Disk Management.
  2. Click Action in the menu bar and select Rescan Disks.
  3. Check to see if the problem is resolved after the rescanning process is done.

Solution 4: Shrink a smaller volume at a time

If you shrink a large volume at a time, you can get error There is not enough space available on the disk (s)to complete this operation. To fix the error, you can try to shrink a smaller volume at a time. For example, if you want to shrink the volume by 150 GB, you can try to shrink by 50 GB each time. Then do it three times. If you still get the error, you can try to shrink a much smaller volume, such as 20 GB. Repeat the process until the error is resolved.

Solution 5: Convert the basic disk to the dynamic disk

The disks we usually use are basic disks. If the basic disk doesn’t have enough spaces for you to complete the operation, you can get this error. As we mentioned in Solution 2, you can free up the disk space to fix the error. But if you don’t want to free up the space, you can convert the basic disk to dynamic disk. The dynamic disk will use the space from other drives so that you can have enough space to complete the operation.

WARNING: If you converted the basic disk to dynamic disk, you couldn’t convert the dynamic disk back to the basic disk. Before you get started, ensure you know what you’re doing.

Here’s how to convert the basic disk to the dynamic disk:

  1. Open Disk Management.
  2. Right-click on the disk which has the problem and select Convert to Dynamic Disk.

    Ensure the disk is a basic disk. If the disk is already a dynamic disk, this method doesn’t work for you. If it’s a basic disk, you can see the drive marked as Basic as follows:

  3. Follow the on-screen instructions to complete the conversion.
  4. Check to see if the problem is resolved.

Hopefully the solutions above work for you. If you have any questions, ideas or suggestions, feel free to leave your comments below.

-->

Note

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

Symptoms

Excel 2008 For Mac Keeps Saying Not Enough Memory

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
Saying

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.

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;

  1. On the View Ribbon
  2. 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.

Excel Not Enough Memory Mac

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:

  1. Right click on Start button
  2. Click Open Windows Explorer
  3. Click Organize | Layout
  4. Uncheck Details Pane and Preview Pane

Excel:

  1. Click File | Open
  2. Click Organize | Layout
  3. Uncheck Details Pane and Preview Pane Outlook:
  4. Open a new e-mail
  5. In the 'Include' group on the Ribbon, click Attach File
  6. Click Organize | Layout
  7. 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;

  1. Close Excel
  2. Open the printer and faxes window (XP) or Devices and Printers (Vista, 7, 8, 10)
  3. Right-click the 'Microsoft XPS Document Writer' printer
  4. Click Set as Default

If your issue is not resolved after you change your default printer, go to method 6.

Excel 2008 For Mac Keeps Saying Not Enough Memory Upgrade

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

Excel 2008 For Mac Keeps Saying Not Enough Memory Foam Mattress

Additional article

Excel 2008 For Mac Keeps Saying Not Enough Memory Available

If the information in this article did not help resolve the error in Excel, select one of the following options:

Excel 2008 For Mac Keeps Saying Not Enough Memory Foam

  • 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