When you open a document in .xlsx format, the values of cells with formulas are not automatically recalculated by default. The cells contain already existing formula calculation results from the file cache.
If you want to force a formula recalculation, follow one of the steps below:
•In the Command menu, select Data > Force Calculate.
•Press Ctrl+Shift+F9.