TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Office

Excel 2007 Resource Issue

Microsoft Office

 
 
Thread Tools Display Modes
Unread 27-11-2007, 09:01 PM   #1
Greg
Guest
 
Posts: n/a
Excel 2007 Resource Issue

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
 
Unread 27-11-2007, 10:00 PM   #2
Techno Savvy
Guest
 
Posts: n/a
RE: Excel 2007 Resource Issue

Hello Greg,

Couple of questions to be answered.

>>> when do u access excel >>>>> after u boot your computer...?

>> what happens when u open a blank worksheet...?
>> before you open existing excel document> check whether it is scanned by antivirus program. ( disable the program and then check.

> 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
--
Techno Savvy
Microsoft corporation
techno.savvy07***********


"Greg" wrote:

> 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

 
Unread 01-12-2007, 08:55 AM   #3
matthew.desario@gmail.com
Guest
 
Posts: n/a
Re: Excel 2007 Resource Issue

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

On Nov 27, 12:24 pm, Greg <G...@discussions.microsoft.com> wrote:
> 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


 
Unread 01-12-2007, 08:55 AM   #4
matthew.desario@gmail.com
Guest
 
Posts: n/a
Re: Excel 2007 Resource Issue

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

On Nov 27, 12:24 pm, Greg <G...@discussions.microsoft.com> wrote:
> 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


 
Unread 01-12-2007, 08:55 AM   #5
matthew.desario@gmail.com
Guest
 
Posts: n/a
Re: Excel 2007 Resource Issue

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

On Nov 27, 12:24 pm, Greg <G...@discussions.microsoft.com> wrote:
> 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


 
 

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 01:08 PM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional