Excel 2003: Not enough system resources to display completely

L

Lady Layla

Ada

Matt is running Windows 2000 -- it does not have MSCONFIG


: Hi Matt,
:
: According to your information, I know that this problem occurs when you
: open any Excel workbook on this computer.
:
: Before we go further, I would like to confirm the following question from
: you:
:
: 1. Does this issue occur when you disable the anti-virus software? Please
: try to disable the anti-virus software temporarily and then check if this
: issue occurs.
:
: 2. I'm not sure if the message occurs when starting Excel with /s switch.
: This method is used to test instead of fix this problem. What is the
: result? Does this message occur when starting Excel with /s switch?
:
: 3. Please take a screenshot of this message and send it to: <
: (e-mail address removed) >.
:
: 4. Does this message occur in other application, such as Word, PPT or
: WordPad?
:
: Based on my research, I would suggest you perform the following steps to
: see if they are helpful:
:
: 1. Have you tried disabling all of your add-ins? I have seen this problem
: over the past couple of months. It was caused by 3rd party add-ins.
: Please try to clear the add-ins on Tools - Add-Ins and then check if this
: issue occurs.
:
: 2. A corrupted printer driver may cause the problem in Excel. Have you
: updated the printer driver? If not, please try removing and installing the
: latest the printer driver from the manufacturer.
:
:
: If the problem persists, we need perform more tests to narrow down this
: problem:
:
: #1: Performing a Clean Boot
: ---------------------------------------
: 1. Click Start, click Run, and then in the Open box, type "MSCONFIG"
: (without the quotation marks). Click OK.
:
: 2. In the System Configuration Utility (MSConfig) window, click to select
: the Selective Startup button.
:
: 3. Click to clear the check mark from the "Load startup items" below
: Selective Startup.
:
: 4. Click the Services tab, click to check the "Hide All Microsoft Services"
: box, and remove all the check marks from the remained Non-Microsoft
: Services. *note that please make sure that you do not uncheck the Microsoft
: services.
:
: 5. Click OK to close the MSConfig window. Click Yes when you are asked to
: restart your computer in order to enable the changes.
:
: 6. After restarting, please check whether this issue will reoccur.
:
:
: If this issue does NOT reoccur following the Selective Startup, please
: continue these steps to find the exact cause:
:
: 1. Click Start, click Run, in the Open box type "MSCONFIG" (without the
: quotation marks), and click OK.
:
: 2. In the System Configuration Utility (MSConfig) window, click the Startup
: tab or the Services tab.
:
: 3. Add one check mark at a time to the entries under the Startup tab or the
: Services tab, and then restart each time to see if the additional entry
: reproduces the original problem.
:
: For more information, please refer to the following article in Microsoft
: Knowledge Base:
:
: 281770 How to perform clean-boot troubleshooting for Windows 2000
: http://support.microsoft.com/?id=281770
:
:
: #2: Starting Windows under safe mode
: -----------------------------------------------------
: If this issue reoccurs, we need to start Windows under safe mode to test.
: To do it, please refer to the "How to Start Your Computer in Safe Mode"
: section in the following article:
:
: 266169 How to Troubleshoot Problems with Standby Mode, Hibernate Mode, and
: http://support.microsoft.com/?id=266169
:
: Then, check this issue occurs under Windows safe mode.
:
: Please try the suggestions on your side and update me the results and
: needed information.
:
:
: Regards,
:
: Ada Pan
:
: Microsoft Online Partner Support
: Get Secure! - www.microsoft.com/security
: =====================================================
: When responding to posts, please "Reply to Group" via your newsreader so
: that others may learn and benefit from your issue.
: =====================================================
: This posting is provided "AS IS" with no warranties, and confers no rights.
:
:
:
 
M

Matt

One of our users receives an error message that is similar to this: "Not
enough system resources to dislpay completely" in Excel 2003. I thought the
problem was due to a particular workbook, but other users with similar
machines can open the same workbook with no errors. Also, this user receives
the error message in Excel even when no workbooks or other programs are open.

The system has 512 MB of RAM, and I've increased the Windows page file to
the recommended size. Also, I installed Office Service Pack 1. None of these
efforts have resolved the issue. Any ideas? I can't find this error
referenced in the MS KB for Excel 2003.
 
A

Ada Pan [MSFT]

Hi Matt,

According to your description, I know that when a user opens an Excel 2003
workbook, he/she receive an error message: "Not enough system resources to
display completely". This problem doesn't occur when opened on other
users' computers.

If I misunderstood your concern, please feel free to let me know.

Based on my experience and research, this problem could be caused by a
variety of factors. I would suggest you perform the following test and let
me know the results:

#1 Empty Temp folder
-------------------------
a. Click Start->Run, type "%temp%" (without the quotation marks) in the
Open box.
b. Click OK to open Temp folder
c. Delete all the files in the Temp folder.
d. Then check if this issue occurs.

#2 Start Excel under safe mode
---------------------------------------
a. Click Start->Run, type "Excel /s" (without the quotation marks) in the
Open box.
Note: There is a space between the Excel and the /s switch.
b. Click OK to start Excel.
c. Click File - Open to open the particular workbook to check if this issue
occurs.


At the same time, in order to better assist you, I would like to gather
some information about your configuration and environment. Please help me
understand your situation by answering the following questions:

1. I am a little unsure the meaning of "this user receives the error
message in Excel even when no workbooks or other programs are open." Could
you please explain the meaning of "message in Excel even when no
workbooks"? Does it mean "no other workbooks" except the problematic
workbook?

2. What is the operating system installed on this problematic computer?

3. When does this issue occur, opening, working on, closing, or printing?

4. Does this issue occur on any other Excel workbook or only this
particular workbook?

5. Is there any anti-virus software installed on this computer? Please try
scanning the disk to ensure there is no any virus on this computer.


If there is anything unclear or you need further assistance, please feel
free to let me know.

Regards,

Ada Pan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
L

Lady Layla

Matt

What other programs/processes are running in the background on this system?
HAve you done a spyware/malware scan recently?


: One of our users receives an error message that is similar to this: "Not
: enough system resources to dislpay completely" in Excel 2003. I thought the
: problem was due to a particular workbook, but other users with similar
: machines can open the same workbook with no errors. Also, this user receives
: the error message in Excel even when no workbooks or other programs are open.
:
: The system has 512 MB of RAM, and I've increased the Windows page file to
: the recommended size. Also, I installed Office Service Pack 1. None of these
: efforts have resolved the issue. Any ideas? I can't find this error
: referenced in the MS KB for Excel 2003.
 
M

Matt

I've done two spyware scans (Adware and MS Beta) and a virus scan. No malware
found, except tracking cookies. I've tried using Excel and nothing else, and
the error still occurs.
 
M

Matt

Your description of the problem is accurate. I tried solutions 1 and 2, but
they didn't fix the issue. Here are the answers to your questions:

1. Even if I have Excel running with NO workbooks open, the error message
continues to appear.

2. Windows 2000

3. The error occurs when opening the workbook. The workbook DOES open, but
anytime a different cell is clicked or a key is pressed, the dialog box
appears again.

4. All workbooks opened on this computer

5. Yes. Norton Corporate Edition 9.0 with the latest definitions. A scan of
the full system returned nothing. I also checked for spyware using two
different programs.
 
A

Ada Pan [MSFT]

Hi Matt,

According to your information, I know that this problem occurs when you
open any Excel workbook on this computer.

Before we go further, I would like to confirm the following question from
you:

1. Does this issue occur when you disable the anti-virus software? Please
try to disable the anti-virus software temporarily and then check if this
issue occurs.

2. I'm not sure if the message occurs when starting Excel with /s switch.
This method is used to test instead of fix this problem. What is the
result? Does this message occur when starting Excel with /s switch?

3. Please take a screenshot of this message and send it to: <
(e-mail address removed) >.

4. Does this message occur in other application, such as Word, PPT or
WordPad?

Based on my research, I would suggest you perform the following steps to
see if they are helpful:

1. Have you tried disabling all of your add-ins? I have seen this problem
over the past couple of months. It was caused by 3rd party add-ins.
Please try to clear the add-ins on Tools - Add-Ins and then check if this
issue occurs.

2. A corrupted printer driver may cause the problem in Excel. Have you
updated the printer driver? If not, please try removing and installing the
latest the printer driver from the manufacturer.


If the problem persists, we need perform more tests to narrow down this
problem:

#1: Performing a Clean Boot
---------------------------------------
1. Click Start, click Run, and then in the Open box, type "MSCONFIG"
(without the quotation marks). Click OK.

2. In the System Configuration Utility (MSConfig) window, click to select
the Selective Startup button.

3. Click to clear the check mark from the "Load startup items" below
Selective Startup.

4. Click the Services tab, click to check the "Hide All Microsoft Services"
box, and remove all the check marks from the remained Non-Microsoft
Services. *note that please make sure that you do not uncheck the Microsoft
services.

5. Click OK to close the MSConfig window. Click Yes when you are asked to
restart your computer in order to enable the changes.

6. After restarting, please check whether this issue will reoccur.


If this issue does NOT reoccur following the Selective Startup, please
continue these steps to find the exact cause:

1. Click Start, click Run, in the Open box type "MSCONFIG" (without the
quotation marks), and click OK.

2. In the System Configuration Utility (MSConfig) window, click the Startup
tab or the Services tab.

3. Add one check mark at a time to the entries under the Startup tab or the
Services tab, and then restart each time to see if the additional entry
reproduces the original problem.

For more information, please refer to the following article in Microsoft
Knowledge Base:

281770 How to perform clean-boot troubleshooting for Windows 2000
http://support.microsoft.com/?id=281770


#2: Starting Windows under safe mode
-----------------------------------------------------
If this issue reoccurs, we need to start Windows under safe mode to test.
To do it, please refer to the "How to Start Your Computer in Safe Mode"
section in the following article:

266169 How to Troubleshoot Problems with Standby Mode, Hibernate Mode, and
http://support.microsoft.com/?id=266169

Then, check this issue occurs under Windows safe mode.

Please try the suggestions on your side and update me the results and
needed information.


Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
M

Matt

Ada, when I restart Windows in safe mode, the error message does NOT appear.
What could that indicate?

Word, PowerPoint, etc., are not affected at any time. I've emailed the
screen shot to your address.
 
A

Ada Pan [MSFT]

Hi Matt,

First of all, thank Layla for her kind reminder. I'm sorry for that I
ignore you are running Windows 2000.

Based on your information, I know that this message doesn't occur under
Windows safe mode. Since safe Mode loads a minimally protected-mode
configuration, disabling Windows device drivers and using the standard VGA
display adapter, some third party applications and some hardware device or
drivers cannot be used during Safe Mode.

To narrow down this problem more, please perform a clean boot on Windows
2000. Windows Clean Boot will isolate the applications we currently use in
a stand alone environment. If some .dll files which affect this issue are
not loaded during Windows Clean Boot, we may be able to narrow down the
root cause of the problem. To use System Configuration Utility to perform a
clean boot, follow the steps below:

(a) Save the msconfig.ex_ attachment (I sent it to you) on your desktop and
rename it to msconfig.exe. Double-click it to run the System Configuration
Utility.

(b) On the General tab, choose Selective Startup, click to clear the
"Process System.ini File", "Process WIn.ini File", and "Load Startup Items"
check boxes. You cannot clear the "Use Original Boot.ini" radio button.

Note: You can click the Normal Startup radio button to return to the normal
Windows Startup after the test.

(c) On the "Services" tab, click to select the "Hide All Microsoft
Services" check box, and then click "Disable All".

(d) Click OK and restart your computer.

Please test the issue in Windows Clean Boot Mode and let me know the
results.

For more information about how to clean boot Windows 2000, please refer to
the following Microsoft Knowledge Base (KB) article:

Note: This article also applied to Windows 2000.

310353 How to Perform a Clean Boot in Windows XP
http://support.microsoft.com/?id=310353

In the meantime, I wonder if you perform all the tests in my previous
response such as update printer driver (or change another printer as
default printer), start Excel with /s switch. If you have other hardware
drivers, please update them all.
Could you tell me if you test them on your side and the results? Thanks
for your time and cooperation.

Regards,

Ada Pan

Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
B

basuki santo via OfficeKB.com

Hi,

I am also have the same problem, with Excel 2000 and Excel 2003
in windows XP. The problem occur after I install several Ms Security Patch,
I don't know which one. Even when I uninstall the security
patch I installed before, the problem still exist.

The message occur when I run Excel, even without opening xls file.

Our system has P4/256MB/XP pro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top