Excel sum not updating
Having said that, we need to be little careful while using show formulas option, otherwise, you might end up with something like below.
Otherwise, this is one of the reasons for excel formulas not working. It’s a mathematical rule to determine an order of operations. =(30 40)*2 So, anything in brackets will be calculated first and then it will go to next operation.
[please refer below example] It’s very important to have correct formatting before using formulas like Vlookup, Hlookup, and Match & Index.
Numbers formatted as a text is one of the common reason for formulas not working in excel. For example, on the left-hand side, you can see Customer ID looks similar to numbers.
If you haven’t done that then you will end up with incorrect results.
How to fix this issue: Head over to Formulas → Calculation → Click on Calculate now/Calculate Sheet option.