Link to home
Start Free TrialLog in
Avatar of JaZz0r
JaZz0rFlag for United States of America

asked on

Excel: "Not enough system resources to display completely"

This error comes up as soon as Excel is run.  No specific documents, it happens to all, even a blank document when Excel is run for the first time.  I have tried both Office 2003 and Office 2007 but the error comes up on both versions.  I have followed the steps all the steps outlined in http://support.microsoft.com/kb/280504 to no avail.  Thinking this may be related to hardware, I have had the manufacturer replace the RAM, CPU, and motherboard.  This is driving me up a wall.  Please help!
SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What is your system information?
(example: amount of RAM, processor, operating system)
Other things to check:
How much of your RAM is being used? (CTRL+SHIFT+ESC - there's a percentage at the bottom [physical memory] and more detailed information on the Performance tab.)

How much hard drive space do you have free? (Start>My Computer [or computer depending on windows version] right-click drive C: (or whatever drive Windows is installed on))
finishing above comment:

once you right click the drive, go to properties and look at the graph
Avatar of JaZz0r

ASKER

jppinto:
If by reinstall from scratch you mean uninstall first then install, then yes that is how I reinstalled.  I have not formatted the drive, but I do plan on imaging the drive and seeing what happens with a fresh OS.

Soulflare3:
HP ProBook 6545b notebook
2.28GHz Intel Core i5 CPU
2GB RAM
WinXP SP3
Physical memory available: 1282424
Physical memory total: 1949036
267GB free hard drive space

It is a farily new notebook and should be able to handle Excel.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This error is not relted to Hard drive storage but with the resourses (memrory).
I did faced this issue many times and tweking the memroy settings using registry fixed them.

I would sugget give it a try...

"Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows"

Click Start, click Run, type regedit in the Open box, and then click OK.
Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management
On the Edit menu, point to New, and then click DWORD Value.
Type PoolUsageMaximum as the entry name, and then press ENTER.
Right-click PoolUsageMaximum, and then click Modify.
Click Decimal.
In the Value data box, type 60, and then click OK. Again,
On the Edit menu, point to New, and then click DWORD Value.
Type PagedPoolSize as the entry name, and then press ENTER.
Right-click PagedPoolSize, and then click Modify.
Click Hexadecimal.
In the Value data box, type a value of FFFFFFFF, and then click OK.



Quit registry editor.. Check the paging files to 1.5 times of the physical RAM as initial value and 3 times as max value.


Reboot the computer.


Avatar of JaZz0r

ASKER

subhashchy:
Thanks for your reply.  Unfortunately that did not fix the issue.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Could have been a bad MS update, or something installed out of order, or even an incomplete install or something like that... many factors. Maybe it was a result of a virus... who knows? At least the problem is *gone* now...
Avatar of JaZz0r

ASKER

Unable to directly resolve issue without reformatting the computer.