Error Message : Not enough system resources to display completely

[Amelia]

Hi friends,

I am facing an issue whenever i try to open any File i am getting an error message as Not enough system resources to display completely.I am facing this issue today only i don't know how to fix this issue can anyone help me out with this.

Thanks in Advance.

[Sam.D]

Sure i will help you out with this before that may i know which version of Office are you using.

[Amelia]

I am using Excel 2003, I try to open the same document on another machine which has Excel 2002.

[Sam.D]

Sure i will help you out with this try to follow the below steps:-

1. Go to the bottom row of data & then select the entire next row by clicking on the row number (in the "margin"). Use [Ctrl]+[Shift]+[Down Arrow] to select all the remaining rows in the worksheet, then click the "Edit" / "Clear" menu item to clear the rows of values & formats.
   
   
2. Go to the far right column of data & select the entire next column by clicking on the column letter. Use [Ctrl]+[Shift]+[Right Arrow] to select all the remaining columns in the worksheet. As before, use the "Edit" / "Clear" menu item to clear the columns of values & formats.
   
   
3. Repeat the above steps for each worksheet in your workbook where you can scroll past the end of your data. Finally, save the workbook, and close it.

[perky182]

Will this also work with Excel '07? I'm having the same issue, but only after I have been working in my workbook for a while. Thanks!

[Trio]

Yeah i think that this must surely work in Microsoft Excel 2007. Sometimes when the size of your data is greater than the default size of your excel sheet these error do occurs so by performing the steps as mentioned by Sam.D you simply increase number of columns and rows so that the data fis in to the excel sheet.

[perky182]

Thank you! I'll be sure to try these adjustments.