Excel temporarily interrupts calculation to carry out the other commands or actions and then resumes calculation. The calculation process may take more time if the workbook contains a large number of formulas, or if the worksheets contain data tables or functions that automatically recalculate every time the workbook is recalculated.
This is driving me a little bit crazy. In my old PC days I used to press either F5 or F9 (I can't remember) to have Excel recalculate.
Manual Calculation Excel Mac Pro
What is the Mac equivalent?
PS: Perhaps this is not the place to ask. If so, please redirect me. :)
Thomas Ayoub3 Answers
AFAIK it's F9 on Windows .
So did you try the keystrokes Fn+F9 ?
IconDaemon
To recalc in Mac:
Command + =
You can try also changing Excel preferences:Command ,Calculation'Manually' radio button
fn + f9 works if you disable mission control shortcut (it is defined as F9 by default)
Excel Manual Calculation Mode
Excel Mac Free
You must log in to answer this question.
Not the answer you're looking for? Browse other questions tagged microsoft .
I have the most irritating problem - every time I enter a value into a cell I get a 'calculating 4 threads' notification and the system starts counting up from 1%,2%,3% and so on until 100% and this process takes a hundred seconds and sometimes even more and while it calculates, Excel freezes and I cannot do anything in the file! This results in a task that should take me one hour to do, now taking me 2 hours to do! Pardon my French, but WTF is going on! Is Excel re-routing the calculations through China! The problem is so severe that it will even slow down my internet feed and slow down other excel files I have open.
I had this problem in the past but it has gotten severe now. I was told that it has to do with formulas which are looping. The size of my Excel file is 6.3 MB and the file contains 190,000 formulas which were replicated in an incremental way (via the offset function in the formula) using the drag function. The more I replicated the formulas, the longer the calculations take.
I have tried copying the entire file into a new Excel file but a portion of the formulas are pasted as values and not formulas when I try and paste the formulas into a new file. A pop up informs me that it is not possible to paste the formulas because it has to do either with the fact that the formulas were pasted from a 'protected view' file or from a different version of excel.
Please instruct me how to fix this most irritating problem. I have no knowledge about formulating formulas. The formulas were formulated for me. So please try and explain as simply as possible how I need to fix the problem.