display completely

How to Repair when Excel Says Not Enough Memory on Windows 10

by

The “not enough memory to run Microsoft Office” error is one of those frustrating errors that pop up unexpectedly while running specific programs such as Microsoft Excel. You might even find yourself unable to open the program because it crashes due to a lack of memory. If you want to know how to solve this problem, follow along with us in this article.

What causes the “not enough memory” error on Excel?

Low memory prompts are common errors in Windows 10. They usually happen when you open large files such as videos, photos, documents, etc., and it causes the system to run out of memory. This error occurs because some add-ons or third-party antiviruses might be blocking certain functions of the file formats. If you don’t want to install another antivirus software, you can try disabling the add-on or uninstalling it completely. You can also use Registry Editor to delete the registry keys related to the add-on. read more

How to Get Rid of ‘Excel ran out of resources’ Error Message

by

In Microsoft Office Excel 2016, you might see the following error message when trying to perform calculations: “Excel ran out of resources while calculating one or more formulas.” This occurs because a circular reference problem exists within the workbook. A circular reference is a situation where there is a relationship between data cells that cannot be broken without causing an infinite loop.

Circular references occur when a cell contains a formula that refers to itself or another cell. For example, suppose you want to find the average of three values in column B. However, it is possible that the value in cell B4 also refers to cell B2. If this happens, the calculation will never end. To avoid this issue, try changing the range of the SUMPRODUCT function. read more