Excel 2007 freezing

This is a discussion on Excel 2007 freezing within the Trading Software forums, part of the Commercial category; I'm running Excel 2007 with Windows XP Pro on AMD 64 x2 dual core 4800, 2 GB ram. Occasionally I ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Apr 2, 2007, 12:18am   #1
Joined Jun 2006
Excel 2007 freezing

I'm running Excel 2007 with Windows XP Pro on AMD 64 x2 dual core 4800, 2 GB ram.

Occasionally I get the "Not responding" message. I'm probably pushing performance with my sheets but I would like to know where the bottleneck may be.

Please refer to the attached Word.doc for a shot of the Task Manager at the time of "Not responding" (scroll up the page). The only aspect which is recognisable is cpu usage - the rest is meaningless. Maybe the clue lies in these unknowns.

The Task manager shows cpu usage at around 50%. Is near 100% not possible?

Excel is set to run dual core.

Grant.
Attached Files
File Type: doc Excel Not Responding, Task Manager picture.doc (28.0 KB, 334 views)

Last edited by grantx; Apr 2, 2007 at 12:24am.
grantx is offline   Reply With Quote
Old Apr 4, 2007, 11:07am   #2
Joined Aug 2003
The Not Responding condition is probably caused by the workbook being too busy at something to let the operating system know what is going on. For instance, if you have any VBA code running, and you have a tight loop that is being repeatedly processed, the workbook will hog the resources. In loops, I usually put the Doevents function - this forces Excel to speak to the OS and let something else have a turn.

Also, if you are doing thousands of recalculations on the sheet - that may cause a temporary freeze.

Although I use the 2007 version, I do not have a dual processor. Have you googled foe Excel dual processor problems? It seems like a recipe for disaster if you have 2 processors trying to share the otherwise monolithic code. It SHOULD work fine, but hey, we are talking Microsoft here.

That's all I can think of for now.
swandro is offline   Reply With Quote
Old Apr 4, 2007, 12:09pm   #3
Joined Dec 2002
it's dual-core, not dual-processor. Apps that aren't written to take advantage of the dual core shouldn't have a problem, most of the work will just be done by the one core which could explain the CPU usage you're seeing.

I've a Core2Duo with both Vista and XP, and both Excel 03 and Excel 07 run with no probs.
__________________
Please do not message me about account deletion or moderation.

For advertising issues ONLY please email advertising (at) trade2win.com
rossored is offline   Reply With Quote
Old Apr 4, 2007, 7:26pm   #4
Joined Jun 2006
grantx started this thread Swanndro,

"if you are doing thousands of recalculations on the sheet - that may cause a temporary freeze. "

I reckon, and not surprised, that will be the problem. I suppose it was just a question of pushing the sheet to the limit.

Rossored,

I'm running a dual core processor, and as I write this reply Excel 2007 keeps flashing (intermittent vba) on the status bar "Calculating (2 processors) ".

No more replies necessary.

Grant.
grantx is offline   Reply With Quote
Old Mar 11, 2009, 4:07pm   #5
 
1 Posts
Joined Mar 2009
Hi, I'm having this problem also "Calculating (2 processors) ".

The workbook isnīt that big at all (370kB on 6 sheets)

The computer I have is a Dell Precision PWS 380
2,00 GB of RAM
Physical Address Extension

I am wondering if I can turn the dual core calculation off?

Torfi
torfim is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 grantx Futures & Options 0 Mar 5, 2007 11:48am
computer freezing osho67 Techies Corner 21 Jul 15, 2005 2:42pm
Windows 2000 freezing up CUDDLES Techies Corner 24 Aug 25, 2004 11:48am
Excel pkfryer Techies Corner 2 Jun 20, 2004 11:57pm
M$Excel? rossored Techies Corner 4 May 21, 2004 8:49am

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)