calculating ( 2 processor(s))--%

Question

hi,

when I enter a calculation or formula my excel shows Calculating:( 2processor(s)) --% and it slow down the working.

please advise because it is very irritating.

Answer 1

Alok wrote:

when I enter a calculation or formula my excel shows Calculating:( 2processor(s)) --% and it slow down the working.  please advise because it is very irritating.

There are two separate issues....

Excel displays "Calculating" on the status line under the worksheet when the recalculation cycle takes a long time.  More about this below.

In your case, I suspect the "Calculating" status takes the form "Calculating:( 2processor(s)) --%" when your worksheet is complex and Excel takes advantage of multithreading.

Usually, multithreading is a good thing.  To learn more, see the http://msdn.microsoft.com/en-us/library/bb687899.aspx.  To learn how to control multithreading in Excel, see the paragraph "Change the number of processors used to calculate formulas" in http://office.microsoft.com/en-us/excel-help/change-formula-recalculation-iteration-or-precision-HP010054149.aspx.

Returning to recalculation....  The slow down is probably due to excessive recalculation.  There are many things that cause this.  For a wealth of information about this, see http://www.decisionmodels.com/calcsecrets.htm.  Be sure to look at many of the links at the top of the page as well.

Generally, a quick-and-dirty work-around is to set Manual calculation mode.  I don't know how to do that in XL2007 per se.  In XL2003, I click on Tools, Options, then the Calculation tab.

However, be forewarned that working in manual calculation mode can be very confusing.  For example, if you copy and paste a range of dependent formulas, most of the pasted formulas might not be recalculated, making it seem like they are not working.  You have to press F9 or ctrl+alt+F9 yourself when you are ready to recalculate.  That's the whole point:  you control when the recalculation is done.

A half-way step might be to simply disable automatic recalculation of tables, if you use them.  In XL2003, that option is under the Automatic calculation option on the Calculation tab.

Answer 2

I had a similar issue and fixed the same.

I have some formula in my excel column which refer another file in my network.  When i copied the same file to home, it was continuously searching for the network file in the formula.

Hope this helps...

Answer 3

I just wanted to share what the fix was for me because I couldn't find a solution anywhere online.   In my case, the issue was that I had added some external links using the INDIRECT() function and I didn't have the file OPEN that I was linking to.  These links don't show up in 'Edit-Links' because they're inside the 'INDIRECT' formula.  The solution for me was twofold:

1. I took this tab out of my main file and put it in a file by itself, so the issue would only present itself when I was working on this specific tab.
2. I would make sure that the file was open before I did anything in the file, even if I wasn't doing something on that tab.  Having the file opened made the slow calculating take less time.  However, it didn't remove it completely, so this is just a fact of having an INDIRECT() function

Hope this helps someone else that has this problem and can't find a solution.

Dave