Frequently Asked Question

Microsoft Excel Functions Not Updating
Last Updated 2 years ago

With most Excel issues, the workbook having problems was created in previous versions. Most cases, if the workbook is re-created in the current version of Office the issues go away.

Here are some other possible reasons:

  1. Make sure that calculated fields are set to numerical and not set to text
    image
  2. Match all opening and closing parentheses in formulas
  3. Enclose workbook and worksheet names with single quotes (' ')
  4. Make sure Excel is set to Calculate Automatically
    image
  5. Make sure formulas do not have leading spaces before the equals (=) signimage

Lastly, you can force Excel to manually calculate by pressing F9 or going to the "Calculate Now"
image


Please Wait!

Please wait... it will take a second!