asked on

High CPU Usage in MS Excel

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.

zorvek (Kevin Jones)

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

JAOsmond

ASKER

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.

ASKER CERTIFIED SOLUTION

zorvek (Kevin Jones)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial