Excel formulas not calculating

Question

Hey guys, I am having a weird problem. I have a workbook with multiple spreadsheets that I have had for over a year and use/update values in almost daily. Anyway, today, one of my sheets is not calculating any of the formulas. I do have calculations set to manual and before saving and that is not the issue. Some of the formulas reference cells in other worksheets, but I don't believe that is the issue either. Basically, to make a longer story shorter, some of the cells are simple additions, such as "=sum(d41,p41,t41)" and d41=500, p41=1000 and t41=250. However, the cell my formula shows the previous value before the updated values. The only way I can seem to get the formulas to calculate correctly is to cut and paste the formula from the cell. See below

Answer 1

I realize that you have indicated that Calculation is set to manual.

However, have you tried changing this to Automatic and also tried the Calculate Now and Calculate Sheet.

Have you checked all of the calculation options for all sheets?

Following screen shot of Calculation options in the Formula Ribbon.

Answer 2

I have done all of the above.

Answer 3

The worksheet might be corrupted. If so, you will probably need to recreate it. I can't think of any other reason for the problem.

Answer 4

I thought this too, but I have multiple alternative saves, before the problem started happening, and they are now having the same issue as well. Anyway, I can cut and paste all the formulas again, just didn't know if this was something someone had ran into before and had a solution for. Thanks