Method 1: Eliminate excessive formattingĮxcessive formatting in an Excel workbook can cause the file to grow and can cause poor performance.

Frequently, Excel hangs or crashes because of formatting issues. Formatting considerationsįormatting can cause Excel workbooks to become so large that they do not work correctly. After you eliminate these issues, your workbook will run more smoothly. Many Excel workbooks have several issues that can problems. If the one of these methods does not help, move on to the next method. To resolve this issue, use the following methods in the order in which they are presented. This article identifies areas in Excel workbooks that use lots of memory and describes how you can make your workbook files work more efficiently.įor more information about the changes that we made in Excel 2013, see Memory Usage in the 32-bit edition of Excel 2013.

Starting in Excel 2013, improvements were made that require more system resources than earlier versions required. Using a 64-bit version of Microsoft Excel. To increase memory availability, consider: Try using less data or closing other applications. When you are working with an Excel spreadsheet, you receive the following error message: There isn't enough memory to complete this action. When you insert columns in an Excel workbook, you receive an error about available memory. You can no longer open as many Excel workbooks in the same instance as you could before you upgraded to Excel 2013/2016. The computer uses more memory when you open multiple Microsoft Excel 2013 workbooks, save Excel workbooks, or make calculations in Excel workbooks. After you upgrade to Office 2013/2016/Microsoft 365, you experience one or more of the following symptoms:

Office 2016 cleanup tool