You can press Ctrl+S to try to save, and then the formula will be recalculated.
If not, you need to click the calculation option icon at the bottom of the formula tab, and then check Automatic.
If there are still problems, you need to look at the actual documents to really analyze the problems.
Please try it first. If it is not solved, you can ask if there are other possible methods.
Thank you, hope to adopt.