We help IT Professionals succeed at work.

High CPU Usage in MS Excel

JAOsmond
JAOsmond asked
on
5,181 Views
Last Modified: 2013-12-10
I have having problems with a couple of Excel 2003 spreadsheets and the calculation features.  I am using a Dell Latitude 1 GHz laptop.  I am experiencing high CPU usages in Excel when I try to use the auto calculation feature in Excel.  The computer hangs for about 10 minutes or so.  Is there any way that I can prevent this from happening.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
You may simply have a lot of calculations. Keep in mind that conditional formatting and VBA code tied to worksheet change events can also consume cycles. How big is the workbook? How many formulas are there? Any VBA code? User defined functions? Do you have other workbooks open at the same time that may have a lot of formulas?

Kevin

Author

Commented:
The workbook is about 32MB with no VBA code.  There are a lot of formulas in the workbook, so it normally takes a minute or two to calculate, but for some reason today the workbook over doubled in size and would take almost all available CPU cycles when it would try and calculate.  We let it run several times for about 5 minutes and then killed the process.  Once we set the formulas to manually update, the workbook appeared to go back to its original size of 32MB.  We are not sure what caused the change today.
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.