I am having an error that happens frequently when opening a workbook. It
says "Excel cannot complete this task with available resources". It also
happens at other times.
I have seen this happen at other times as well, but it happens most
frequently on workbook open. It happens most when the computer has just come
back from the screen saver or having been locked (or both).
I am working in Excel 2007 on a machine with 2 GB of RAM and 4096MB of
virtual memory. There are plenty of available resources when I check the mem
usage in task manager.
The information I've read about this error doesn't seem to relate to it. I
am not using named ranges, nested names, or an older version of Excel.
After closing the error message and a secondary one which has code 101648
after I hit "CTRL+SHIFT+I", the screen becomes messed up. The application
toolbar and parts of the screen "ghost" onto other screens. I then have to
drag another window across them to get them to redraw. Excel has to be
restarted. It doesn't appear to be related to how long my computer's been
on. Remote Desktop also seems to impact my base machine sometimes causing
this.
Any help is appreciated.
Try removing all add-ins, both xla and com. The easy way to do this is with
the Add-in Information Lister (free) at
http://www.add-ins.com/addins_information_lister.htm. It will list all
installed add-ins, and then give you quick access to the dialogs that remove
xla and com add-ins.
Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
>I am having an error that happens frequently when opening a workbook. It
> says "Excel cannot complete this task with available resources". It also
[quoted text clipped - 24 lines]
>
> Any help is appreciated.
mcleester - 14 Mar 2008 15:18 GMT
Sadly, I can install any programs (work computer). I do have one .xla add-in
installed. Should I rewrite it to be an XLAM? You've heard about this
causing a problem before?
> Try removing all add-ins, both xla and com. The easy way to do this is with
> the Add-in Information Lister (free) at
[quoted text clipped - 35 lines]
> >
> > Any help is appreciated.