Remove "Calculate" from Excel.

Solved/Closed
lonova78 - Jan 29, 2009 at 12:54 AM
 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.

3 responses

How to remove /hide the calculate option from status bar which is located in left side corner of the excel sheet
16
dellmania Posts 13 Registration date Thursday September 11, 2008 Status Member Last seen February 26, 2009 12
Jan 29, 2009 at 06:35 AM
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.
12
select the whole file, then copy, thern paste special....
2