Search : in
By :

Remove "Calculate" from Excel.

Last answer on Oct 5, 2009 12:20:15 pm BST lonova78, on Jan 29, 2009 5:54:54 am GMT 
 Report this message to moderators

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.

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Remove "Calculate" from Excel. » in :
Excel - IF formulas for Printing and Calculation ShowExcel - IF formulas for Printing and Calculation Issue Solution Note Issue I am trying to get Excel IF formulas to print a text and calculation based on true/false. Such as, if I have some dates, and I don’t need to send a notice to a...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Excel – Formula for cell calculation ShowExcel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Download ExcelExplorer Show
Download Furniture Removal - Volume Calculator ShowDescription The application is designed by Capital Removal - Furniture Removal Canberra ACT. It has won loads of awards for its perfection. Furniture Removal - Volume Calculator is a tool that will calculate items quantities in cubic metres and...
Download Excel Password Recovery Master Show
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Utilities for Removing Common Viruses and Worms ShowWhat is a virus removal tool? A virus removal tool is a small executable file for cleaning a machine which has been infected by a particular virus. Each removal tool is therefore uniquely capable of eradicating a particular kind of virus, or a...
Ask your question Reply

1

dellmania, on Jan 29, 2009 11:35:18 am GMT
  • +4

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.

   
Reply to dellmania

2

 shanthi, on Oct 5, 2009 12:20:15 pm BST
  • +3

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

   
Reply to shanthi
Ask your question Reply
They need your help