Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I believe this happening for two weeks now: Excel 2007 (on Windows XP) is acting funny on my computer; any medium sized sheet with some formulas in it takes a significant amount of time recalculating.

I can see this because the "calculating: 2 processors xx%" message was almost unseen before and now it appears on most operations like calculating a formula (on one cell), saving, previewing, etc.

If the sheet is complex (lots of formulas) I have to disable automatic calculations because excel renders as unusable - it hangs for a really long time, measureable in minutes.

Any idea on what may be causing this?

ps: this is a Core2 Duo computer with 2 Gb of RAM

share|improve this question

There are many reasons why this could be happening, but there is one thing I have seen happen frequently. Do you have any external data sources referenced in the workbook?

Every time the workbook recalculates, it does them all. So, if the file is connected to external data which it can not find, it will keep trying to find it, thus increasing process time. Or if there are a lot of external references it can seriously slow down the process as it works it way through all of them.

Here is a good article addressing performance related to calculations.

MSDN article - Improving Performance in Excel 2007

share|improve this answer
this is the likely cause if the types of formulas have not changed significantly. Lots of vlookups and volatile functions will cause issues as well, and the referenced article is worth looking at – datatoo Jun 8 '12 at 16:49
up vote 0 down vote accepted

It was something wrong with my profile. I deleted my old user profile and after that the computer got a bit more responsive...

Not a true "solution", but I sorted my issue this way.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .