Processor usage unusually high

Hi,
I am using a Dell T7500 Workstation 24GB Ram 2 * X5570 2.93 ghz processors. set to use 8 processors
and CPU running at 98% memory 28% Disk 1%
This is while doing calcs on an Excel worksheet consisting of 123,000 rows and 130 columns.
The data size shown in the Task Manager is 1,309 MB   The max Excel can handle is 2,000 MB
My question is:  Why is the processor usage so high ?
Thanks
Ian
raceproretiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You probably have to many dependencies and references between cells. Maybe there a functions used which do not allow for proper checking for a required update, and so they need to be recalculated as soon as a reference cell is calculated (not necessarily changed in value).
If there is a lot of screen output, that can also cause high CPU though not necessary.

Do you trigger calculations manually, or are they done on opening the workbook?
0
Sam Simon NasserIT Support ProfessionalCommented:
maybe there are other processes are working, not excel issue. maybe windows update is running, antivirus is running scheduled tasks, etc ..
check them.
0
raceproretiredAuthor Commented:
Hi Guys, thanks for your quick responses.
Sometimes the workbook opens when calc set to auto and other times set to Manual.
Either way during the calc process it uses max processor power.
nearly all of the usage is shown as Excel. This has been an ongoing problem for a few years.
I'm beginning to wonder if these processors are powerful enough
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

raceproretiredAuthor Commented:
I do have some columns that are 'spare' scattered between data columns.
Would that cause it to slow down ?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
In my experience the only action with high probability of being helpful is to reduce the amount of data the workbook keeps.
0
raceproretiredAuthor Commented:
I have already done this. Originally the workbook contained 842,000 rows and growing,  and I have divided them
making 17 files with rows anything from 35,000 to 155,000. If I divide them any more it will end up
being a highly cumbersome project which it already is. But if there's no other option then I may well have to do that.
However running models requires the full data. I was wondering is it possible to load the full data on another computer
and just use the necessary formula columns on the main PC. Meaning running the program via the network ?
This way I would be using two Excel instances thereby increasing data max to 4GB, it would also share the CPU usage equally.
Would that work ?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The machine running Excel and opening the workbook has to perform all calculations. You cannot distribute the load. You can allow more or less cores to participate, though.
0
raceproretiredAuthor Commented:
I have allowed 8 cores to run. and using the 64 BIT version.
Excel is probably not suitable for heavy duty work.
I'm at a loss why Microsoft don't come up with a much larger
max capacity say 5 or 8GB instead of the small 2GB
I was going to wait to see what their 2018 version is like but can't
see them increasing it beyond the 2GB.
I may have to look for other solutions.
I am feeling very deflated and just about giving up on this project.
Thanks for listening.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
a increasing the maximum size would make the effect worse, not better, so what is the point?

Heavy computing is done much better in applications developed for that task. Excel is not. Using a 64 bit executable doesn't change processing power, just the amount of data to process at max.
But if you have tasks like running the solver, Excel should do a good job.
0
raceproretiredAuthor Commented:
I don't understand. It seems to make sense if a file say 1,500MB in an imaginary Excel Ver with 6GB
capability would be faster than it would be in a 2GB maximum environment.
It certainly did a good job when my files were much smaller.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Why? If you say you can now count to 100 instead of 10 as before, does it make counting to 10 faster? ;-)
0
raceproretiredAuthor Commented:
Okay, you win. I am no expert and you are. I bow to your superior judgement.
Anyway this has gone no way to solving my issue.
I may have to find another way of storing the data.
Excel is clearly not suitable for handling the workload that I have.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
That's probably correct, and all you can get as advice without us having details available.
0
raceproretiredAuthor Commented:
I think the only way to solve the "details requirement" is to send a worksheet to you for testing yourself at your end
but you may not have time for that which I fully understand.
0
raceproretiredAuthor Commented:
Thank You kindly for your explanations.
I realise the only solution is to upgrade my PC and in the throes of doing that.
0
raceproretiredAuthor Commented:
I have concluded the CPU and the hard drive is old technology even though it is
a Dell workstation however it is 10 years old and cannot be upgraded.
Hence I need to replace it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Processors

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.