Member Avatar for seevas

Hi,

If I lock my computer after I run a macro in Excel 2002, I am getting the error as
"Not enough system resources to display completely" . As per the microsoft document(
http://support.microsoft.com/?kbid=873366) I applied the patch as well, but still I am getting the same error. But it is working fine, it the system is not locked. Your help would me much appreciated.

Thanks in Advance.
Seevas

  • 4 Contributors
  • 3 Replies
  • 191 Views
  • 9 Months Discussion Span
  • Latest Post Latest Post by groc2005

Dani AI

Generated

— short, practical summary and focused troubleshooting you can use now.

This Excel message is a generic “available resources” error and can be triggered by several unrelated causes (large/complex workbooks, add-ins, printer drivers, or external agents). If the problem only appears after you lock/unlock the workstation, that narrows the fault to things that interact with the desktop/session or that leak graphical/handle resources while the session changes. (learn.microsoft.com)

Quick isolation checklist (do these in order):

  • Reproduce the problem step‑by‑step (run the macro, lock with Windows+L, unlock). Note exactly when it first appears and whether Excel is still running.
  • Start Excel in Safe Mode and test the macro (excel /safe). Safe mode disables add‑ins/startup items so you can tell if an extension is involved.
  • Try a clean boot / disable non‑Microsoft startup services and antivirus temporarily. Also change the default printer to the Microsoft XPS Writer while testing (Excel uses the default printer to help render). If the error stops, re-enable services one‑by‑one to find the culprit. (learn.microsoft.com)

Third‑party agents and display/handle leaks

  • Several admins reported that remote‑management/agent clients (historically LANDesk) caused the same message after lock/unlock; if you have any management/remote tools installed, update or temporarily remove them to test. raised this in the thread and community posts back it up. (office-forums.com)

VBA and resource leaks to check last

  • If the macro creates/destroys many UI objects or automates other apps, ensure COM/UI objects are properly released (quit external apps and Set object = Nothing in reverse creation order). For dynamic UserForms, clear images/captions before removing controls. Monitor handle/GDI counts while reproducing the problem (Task Manager/Process Explorer or [GDIView]). If counts climb and never fall you have a leak to fix. (stackoverflow.com)

If these steps don’t isolate it, include: exact OS/version, Excel build, the minimal macro that reproduces the error, and whether the machine runs a management/print agent — that information points to the right fix.

Recommended Answers

All 3 Replies

Member Avatar for MartyMcFly

Is the macro correct, some math formula can loop and create endless data, I was taught how to do that in Fortran (eh, useful stuff :( )

Secondly check that you have enough free space on you primary partition, ie, you C:\ drive. I guess you need about 500mb free at least.

Member Avatar for ladybug

If you're running LANDesk on your network there is a patch for this problem. Try this link:

Member Avatar for groc2005

The link doesn't work...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.