Excel returning incorrect result even though evaluation gives the correct result

[Dichotomy66]

The spreadsheet is posting an incorrect result, Even though when I run evaluate formula the final result inside its popup is correct, when finished a different result is posted to the spreadsheet

[#2]

@Dichotomy66 Would be helpful if we could see the formula, the expected outcome and the result it produces.

[#3]

It is not a formula issue as this is happening in a few different places on the spreadsheet. As I said the "evaluate formula" returns the correct answer as its final result but the spreadsheet then posts a different result. This spreadsheet and all its formulas has worked fine for a year or more with no changes. Then in the last few days it stopped working correctly

[#4]

@Dichotomy66 

Is calculation set to 'Manual'?

[#5]

Tried it at auto and manual and the error recurred. I reinstalled Office365 and for now it seems to be working @Detlef Lewin 

[#6]

Spoke too soon the reinstall did not correct the problem.

I attached the sheet ,,, look at cells  AO7:AO16 for example though it occurs in other places, IN particular AO11 and AO12. Running evaluate formula leads to a different result which is correct

[#7]

@Dichotomy66 Wow, what a schedule. For an outsider like myself, the formulae are difficult to grasp without a thorough analysis of the entire workbook. When I opened the schedule I got a warning that it contained circular references. Not a good sign. Then I evaluated the formula in AO11 and noted a large number of #VALUE! errors, and after about a hundred clicks it returned 0.00, exactly what is in AO11. So, I'm afraid I'm not the right person to help you here. Sorry!

[#8]

Yeah it is an extremely complex sheet for sure @Riny_van_Eekelen 

And for some reason every now and then it will go from working fine for months to suddenly getting a bug. Fortunately I know the sheet well enough that usually I can fix them quickly.

[#9]

@Dichotomy66 

Do you happen to have iterative calculations enabled?

I haven't looked at the workbook yet (My work environment doesn't take kindly to XLSMs).

[#10]

@Dichotomy66   Hi guys, I experience this with my spreadsheets as well and have found a solution for my spreadsheets.

The incorrect answer problem occurs whenever I have circular references in my formulae or if that little green triangle pops up in top left of cells anywhere in my spreadsheet.

If I remove circular references and select "Ignore error" wherever there is a green triangle in the cell, then in my case the cell returning incorrect answers suddenly returns the correct answer

(If one hovers the mouse over a cell or series of cells with the green triangle top left, a sub-menu appears. I always choose "Ignore error" and the green triangle goes away.)

I hope this helps you too