Excel 2007 Resource Issue

[Greg]

One of my users is having a very strange intermittent problem. They'll be
working using Excel 2007 with no problems but then they'll open a document
(any random document, different ones each time and all very small - 32k, 40k,
etc...) and Excel will start throwing resource errors such as:

insufficient memory to create the bitmap. close one or more applications to
increase available

excel cannot complete this task with available resources. choose less data
or close other.

not enough system resources to display correctly.

The crazy thing is, there's 1Gb of RAM on this machine and I open
TaskManager and it's not maxed out. Excel isn't even gobbling it up.

I looked at CPU utilization this time when it happened and I noticed Excel
was hovering around 50% for about 5 minutes while I let it run. The screen
gets all choppy (can only see part of the Excel layout/menus/data). I can go
to other programs and open them but Excel is hosed. Ultimately I END TASK
and start again and it works fine.

It's almost like it spikes right away when opening the file and never
recovers. Anyone have any ideas?

Thanks!
Greg

 

[Techno Savvy]

Hello Greg,

Couple of questions to be answered.

access excel in safe mode . Start>run>msconfig>boot.ini>safe mode with networking.

If none of the steps helps in access excel, then there might be installation
issues.
Uninstalled only excel from advanced mode and install using the disk.

let us know the status of the issue

 

[matthew.desario]

Greg:

I have the same exact problem with one of my users, in the same
circumstances. Intermittent, small files, cpu utilization goes crazy
when I click on the error dialogue boxes, plenty of RAM. I have 3GB
so memory isn't your problem.

I'm going to delete the app data\microsoft\office and local sett\app
data\microsoft\office folders and and re-load. Sometimes that works
wonders fro Adobe and the previous versions of Excel (XP & 2003).

Easier than reinstalling, which imho is a lame fix unless you're
worried about other programs or updates that may have overwritten an
origianl file. That's not the case here, in a highly restricted, and
managed environment.

Also, are these native 07 files or old files that you either converted
or run in compatibility mode? Any warnings pop up when the do open
okay, like messages about converting, compatibility mode, or linking
to other workbooks?


Matthew