A large number of users have asked questions on the Microsoft forums relating to this issue. This error occurs when you’re trying to fill or copy different formulas on a huge worksheet area, or if the worksheet is extremely large. The error message received in this case will show in different formats: In today’s article, we will discuss the reasons for this error showing up, and also how to prevent it from happening. Read on to find out more. microsoft forum community

Why does Excel say not enough memory when printing?

Firstly, the specific reason for this error occurring is hidden in the way Microsoft Excel has been built or due to the next factors:

There are other applications that take too much RAM memory Your printer’s drivers are not properly installed or are out-of-date. The printer device is not set as default on your computer An exceeding volume of data or formulas is copied into your Excel spreadsheets

Every instance of Excel is limited to 2 GB (gigabyte) of memory, and also 32,760 source cells when you’re using a smart fill option. Depending on the specific action you’re trying to perform, both or one of these limitations will cause the above-mentioned error to appear.

How do I fix Excel printing error not enough memory?

1. Update or reinstall your printer driver

In case you want to escape from the Excel printing not enough memory error, you should update your printer drivers to make sure it’s not the cause for the issue.

  1. Next, expand the Print queues section.

  2. Right-click on your printer and select Update Driver.

  3. Pick the Search automatically for drivers option.

  4. Wait for the process to complete and restart your PC.

If your driver is already updated and the Excel memory error is still happening, see the next solutions to resolve it fast.

2. Close programs running in the background

3. Set your printer device as the default

Conclusion

In today’s how-to guide we talked about the best methods to apply if you’re working with a big MS Excel file and you are stopped by memory or cell limitations. Please feel free to tell us if this guide has proven useful in your case. You can do so by using the comment section below.

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ