• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

Excel 2007:Not enough system resources to display completely

Hi,

When I am working on an excel sheet I get this message. Please assist.
0
navin_peddi
Asked:
navin_peddi
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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



0
 
patrickabCommented:
navin_peddi,

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

Patrick
0
 
navin_peddiAuthor Commented:
Thanks for the valuable information.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now