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.
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.