Excel 2007 : Error in Excel 2007: Not Enough System resources to display completely

[solomon2211]

Please help to sovle this problem. My PC has CPU 3GHz and RAM 1GB. Excel 2007 SP1

Thanks

[broro183]

hi,

For anyone to be able to provide an informed response you need to provide more detail...
Does this message occur when you start Excel?
or when you open a specific file?
or when you perform a specific action in any file?

What is contained within the file?
How large is the file?

You may find useful tips in some of the results listed by the below Google:
http://www.google.co.nz/search?hl=en...%22+excel+2007

hth
Rob

[solomon2211]

Thanks for your reply.

The error occurs when I input data or change data.

Could you be of help?
Thanks

[broro183]

It is hard to provide help when you are not providing very much detail - how many of my previous questions have you answered with your last post (at a stretch it could be half of them)?
Can you please try to give me & other potential helpers some more context to your problem (ie the answers to my questions & anything else that may be relevant)?

To expand on "What is contained within the file?"...
Does it have a lot of sheets, or a lot formulae that reference entire columns, or sumproduct formulae, or charts or pivot tables or???

The google search that I provided a link to is from the ".co.nz" site & I understand it may not work for you so here is a link to a similar search on the ".com" site which you can hopefully access:
http://www.google.com/search?num=100...2excel+2007%22
On my computer this only lists 37 results, if you take the time to look at some of the results it is quite likely you will find an issue that occurs in a similar manner to your own & there may be a suggested solution...

hth
Rob