Excel 2007:Not enough system resources to display completely


When I am working on an excel sheet I get this message. Please assist.
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello navin_peddi,

you don't give us much to go by. It looks as if your computer does not have enough memory or processing power to display all components of your spreadsheet. you could

- try to open the workbook on a more powerful machine.
- upgrade your memory
- reduce the complexity of the workbook

There are many ways to improve performance in 2007. See here: http://msdn.microsoft.com/en-us/library/aa730921%28office.12%29.aspx

cheers, teylyn


Please provide information on;

- size of workbook
- numbers of formulae in workbook
- numbers of individually formatted cells (as opposed to formatted rows or columns)
- installed RAM on your pc
- size of page file set and used
- speed of your pc's processor
- available space on your hard disk
- what other applications you are running when you get the error mesage

navin_peddiAuthor Commented:
Thanks for the valuable information.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.