Remove "Calculate" from Excel. [Solved/Closed]

lonova78 - Jan 29, 2009 at 12:54 AM - Latest reply:  raj
- Jul 28, 2011 at 05:47 AM
Hello,

When opening a saved sheet with data in excel,I get to see "calculate" mentioned on the bottom left.
The problem is when this "calculate" is displayed, I have issue in dragging a cell formulae to the other cell.
For example:

Image in A1 digit 2 is mentioned and B1 digit 32 is mentioned, and
Image in A2 digit 5 is mentioned and B5 digit 30 is mentioned.

Now, I put the Sum formulae in C1, when I drag it to C2, or if I use the shortcut formulae Ctrl D, I get the same value as in cell C1 and C2.
Then I have to manually double click C2 to get the actual value.

This only happens when I get this "Calculate" mentioned on the excel.
Now how do I remove this "calculate". So I can work more easy.

Please advice.
See more 

3 replies

Best answer
14
Thank you
How to remove /hide the calculate option from status bar which is located in left side corner of the excel sheet

Thank you, shanthi 14

Something to say? Add comment

CCM has helped 1695 users this month

dellmania 14 Posts Thursday September 11, 2008Registration date February 26, 2009 Last seen - Jan 29, 2009 at 06:35 AM
12
Thank you
It is set to automatic. Then all you have to do is to set it to manual each time you want to calculate the digits on your own. Then set it back to automatic when you are done.
2
Thank you
select the whole file, then copy, thern paste special....