How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Zabo04 Your Own Question
Zabo04, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 283
Experience:  Experienced in Word, Excel, Access, Powerpoint, and Outlook.
Type Your Microsoft Office Question Here...
Zabo04 is online now
A new question is answered every 9 seconds

I am unable to add formulas (i.e. Calculate Field is

Customer Question

I am unable to add formulas (i.e. Calculate Field is disabled) in Microsoft Excel
Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Zabo04 replied 10 months ago.

What version of Excel do you have?

Expert:  Zabo04 replied 10 months ago.

From your question, the most likely cause is that the Workbook Calculation has been set to Manual. To set back to automatic, you would need to click on the Office button in the upper left of Excel with your file open. Click on Excel Options, in the left pane you will see some categories, you want to click on the Formulas category and new options appear in the right pane. Under the heading "Workbook Calculation", you want to select the radio button for "Automatic", click OK and formulas will now automatically calculate.

Expert:  Zabo04 replied 10 months ago.

While in manual calculation mode you can determine when Excel calculates by pressing F9 to force Excel to perform all calculations on the entire workbook or Shift+F9 to calculate only the current worksheet.

Expert:  Zabo04 replied 10 months ago.

Please let me know if that answered your question or I misunderstood what exactly Excel has disabled on your system/workbook.

Related Microsoft Office Questions