Cell does not automatically reflect the result of a formula

microsoft-excel
22,164

Solution 1

Are your Calculation Options set to Manual? If they are, set them back to Automatic.

enter image description here

Solution 2

Set Calculations to Automatic in Formulas > Calculation Options > Automatic for excel to update contents of formulas automatically.

If you don't want automatic calculations but want to trigger a calculation after values are changed press the "Calculate Now" button of F9.

Share:
22,164

Related videos on Youtube

Vellarad
Author by

Vellarad

Updated on September 18, 2022

Comments

  • Vellarad
    Vellarad over 1 year

    MS Excel 2010 is not updating formulas. For instance, I have this formula in cell D2:

    =A2 + B2

    If I put data in A2 and B2, D2 does not show the result.

    However, if I enter values in cells A2 and B2 first BEFORE I enter the formula in D2, it shows the result, but the formula only seems to work "once." If I change the values in either A2 or B2, D2 does not get updated.

    Can you help me ?

    • Dave
      Dave almost 12 years
      What do you mean by "if I first fix the value of cell A2 and B2"
    • assylias
      assylias almost 12 years
      Are you on automatic calculation mode: File > Excel Options > Formulas > Calculation options > Automatic?

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

What would be the the mathematical equivalent of this excel formula? =PMT()
Grand Average in place of Grand Total in Pivot Table
How can I define a global cell style in Excel 2010?
Use Excel VBA If value in column a is not in column b then add value to column c
How to find time difference between two rows of one column in excel sheet?
Splitting up an address into different cells
How to write Excel macro to copy selected row of data between two sheets?
Excel - How to create a worksheet that refresh daily and save old info
Alphanumeric cell format (using custom format)
How to convert a line graph into data?