Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel not runnning all cores at 100%

26 May 2011   #1
Reubenb04

Windows 7 Ultimate x64
 
 
Excel not runnning all cores at 100%

Hi all,

I run alot excel & visual basic simulations that normally take about 4-7hrs to calculate. i've noticed through task manager(performance) that all 4 cores are running but only 1 core is running at 90% and the other 3 running at about 60%.

Is it possible to have all 4 cores running at 100% My hope is that all cores maxmised will slash the proccessing time by atleast 20%.

Any help will be much appreciated.

my system:-
-Windows 7 Ultimate 64bit.
-Intel Q9650(3Ghz) overclocked to 3.5Ghz
-Gigabyte GA-P35-DS3
-4gb DDR2 800Mhz
-250gb WD Cavier Blue
-Freezer Pro rev2




Attached Thumbnails
Excel not runnning all cores at 100%-screen-shot.jpg  
My System SpecsSystem Spec
.
26 May 2011   #2
HammerHead

win 7 X64 Ultimate SP1
 
 
Ram Disk

Would a ram disk be of help? I know that doesn't solve the cpu core issue.
My System SpecsSystem Spec
26 May 2011   #3
Reubenb04

Windows 7 Ultimate x64
 
 

Quote   Quote: Originally Posted by HammerHead View Post
Would a ram disk be of help? I know that doesn't solve the cpu core issue.
Thanks Hammerhead, what is a ram disk.
My System SpecsSystem Spec
.

26 May 2011   #4
HammerHead

win 7 X64 Ultimate SP1
 
 
Ram Disk

This can explain it better than I can.

RAM disk - Wikipedia, the free encyclopedia

There is software available to set up ram disks, some of it is free. IMO if you are not ram starved you might as well put it to work.
My System SpecsSystem Spec
26 May 2011   #5
Reubenb04

Windows 7 Ultimate x64
 
 

Thanks, will try that and see how much diiferent the performance will be.
My System SpecsSystem Spec
26 May 2011   #6
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

Hi Reuben,

Unfortunately, I suspect the thread loading is controlled by the application - in your case Excel, so there may not be much you can do about it.

I have similar issues with a different set of software running, ironically also simulations, but using geological and mine planning software. I have used this counter-intuitive? technique to squeeze a little bit more out of the active CPU threads, but the gain is really quite minimal, but there is at least a little gain. With the software I use, the simulations are more RAM intensive, so I split my work into multiple copies and run several instances of the simulation since I have 24GB of RAM I can utilise, but I also try to maximise the CPU usage.

The trick in my case is to avoid spreading the work across all the cores if they aren't being used fully. For example, I only allow the executable to utilise for example core 1,2 and 3. That way, there isn't any overhead lost when the work swaps between cores as it requires, if that makes sense.

Try this:

1. Open Task Manager, under the Processes tab, find EXCEL.EXE *32 (assuming your are using 32 bit Office)
2. Right-click on EXCEL.EXE *32 and then select Set Affinity
3. By default <All Processors> will be ticked - try limiting Excel to only use 3 threads only, and see if that works for you.

As I said, it worked for me with some processes I run, but not all of them, so it may not work for Excel.

Let us know how you get on.

Regards,
Golden


Attached Thumbnails
Excel not runnning all cores at 100%-capture.png  
My System SpecsSystem Spec
26 May 2011   #7
Reubenb04

Windows 7 Ultimate x64
 
 

Many thanks Golden, am currently running a simulation using Ram Disk. Still only one core is at 94% and the other 3 about 64%. Normal time is always about 7hrs and hoping to hit about 5hrs(an opportunistic 20% reduction in processing time with ram disk). Will definitely try your method afterwards.

cheers.
My System SpecsSystem Spec
26 May 2011   #8
DarkXeno

Windows 7 Ultimate x64 SP1
 
 

This all depends on what version of excel I believe that most office apps are built with a single core in mind to be able to work with older machines, your best bet is to set excel to one core VB to another core giving them full access to them and then leaving the other two cores for windows task so it doesnt lock up.
My System SpecsSystem Spec
Reply

 Excel not runnning all cores at 100%




Thread Tools




Similar help and support threads
Thread Forum
Dvd/Usb not runnning at boot for installation
Hi, I purchased a new laptop of HP Model- 15n-012TX . I want to install windows 7 over inbuilt Windows 8. But when I insert DVD or Booted Usb ,It just cnt going to boot from it and general windws 8 starts. I changed boot order and tested but still the same result... stuck at it please...
Installation & Setup
3 CPU cores and not 4?
I have a AMD 955 Quad but now it's only showing 3 cores on my gadget. Is there a way to check this out so I'm wondering if there is something wrong with my CPU?
Hardware & Devices
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
What Would You Do With 48 Cores?
Saw this today and thought, hmmm, what would I do with 48 cores~~:confused::geek: What Would You Do With 48 Cores? | AMD at Work
Chillout Room
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:01.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App