Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Report
-
 raj -
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
Related:

3 replies

Answer 1 / 3

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Answer 2 / 3
Posts
13
Registration date
Thursday September 11, 2008
Status
Member
Last seen
February 26, 2009
 12
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.
Answer 3 / 3

select the whole file, then copy, thern paste special....
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!