excel not enough memory resources to display completely

Excel not enough memory resources to display completely windows#

Click on the search box and type “ Programs and Features“.Ģ. Repairing MS-office applications may solve this issue on your computer.ġ. Check if you are still facing the same issue or not. Relaunch Excel window on your computer to let the changes take effect. Finally, click on “ OK” to save the changes. In the Add-ins window, uncheck the add-in which seems unnecessary to you (which you don’t use that much).Ĩ. Click on “ Go” on the right side of the window.ħ. You will notice the list of add-ins on the right side of the same window.Ħ. In the Excel Options window, click on “ Add-ins” on the left-hand side of the window.ĥ. Now, scroll down and on the left-hand side of the same window, click on “ Options“.Ĥ. In the Excel window, click on “ File” in the menu bar.ģ.

Excel not enough memory resources to display completely windows#

Open Excel worksheet where you are facing the problem.Ĭlick on the Search box beside Windows icon and type “ Excel“, click on “ Excel” to open Excel on your computer.Ģ. In order to disable unnecessary Excel add-ins, simply follow this steps-ġ. Sometimes the add-ins of Excel may cause this problem at your end. If you have done this and still the error persists, go for the next fix.įix-2 Remove unnecessary add-ins from Excel. Try to reduce the number of charts and the charts with huge number of data points. Check if the worksheet contains any unnecessary shapes or charts.ĭ. Recheck all the calculations in the worksheetĬ. Recheck all the formulas you have used in Excel worksheet.ī.

After opening the worksheet, check these following parameters-Ī. Fix-2 Remove unnecessary add-ins from Excel-įix-1 Check the contents of the spreadsheet-ġ.Fix-1 Check the contents of the spreadsheet.I hope this tip will ease someone's life and avoid going thru the same nightmare I did. Everything should be fine.ġ - Add a DummySheet(obviously without any controls) Ģ - Use workbook BeforeSave event to activate DummySheet -This will grant that once the workbook is reopened, opening sheet will be DummySheet, which will not have any controls Ĥ - If everything went fine, you might consider a restyling on DummySheet so opening sheet show something like 'Loading data.' Opening a workbook EXCEL 2010 which opening active sheet have controls (buttons, checkboxes, etc) in it, it will likelly give you error 'Not enough system resources to display completely'.ġ - Remove controls (button, checkbox, images, listbox, etc) from opening worksheet, save, close and reopen workbook. I thought It was something that I did wrong.Ī carefull investigation that lasted more than 60 hours of brain and fingertips burning (along with all the sorrow because time was running out too fast), I have reached the following conclusion. Since this a rather complex project, I did not related this behavior with EXCEL 2010. It never happened during workbook operation, only during opening Sometimes it hapened and sometimes it did not, even using the same workbook (but different opening sheets) Opening workbook it gives error 'Not enough system resources to display completely' Re: 'Not enough system resources to display completely"Ī couple of months ago, I have found out that some older EXCEL workbooks, that worked fine for years in versions from 2000 to 2007, start giving error 'Not enough system resources to display completely' when trying to open them on EXCEL 2010.