Manual calculation causing lines through certain cells in excel (not formatting related)

Question

I always use manual calculation for excel and have never had an issue before but now there are certain cells throughout my workbook with lines through them. It looks as if strike through formatting is applied to these cells however it is not. There is also no other formatting or conditional formatting causing the issue, as I have cleared formatting and the line is still there. The only thing I have been able to figure out is that when I turn on automatic calculations the issue appears to go away but as soon as I turn manual or partial calculations on the issue returns. There are circular references in the workbook and I do have a circuit breaker in the model and iterative calculation enabled. I have also asked a co-worker to open the same version of the model and he has no issues with it, so it must be an issue with my excel. Any help here would be greatly appreciated.

Thanks

Answer 1

For reference, this is a screenshot of the issue.

Answer 2

I think the blog post linked to below answers your question :)

https://techcommunity.microsoft.com/t5/excel-blog/stale-value-formatting/ba-p/3887098

Answer 3

Thank you! That was it.

Answer 4

If your computer isn't very old and slow or have extremely complex formulas, why would you "always use manual calculation"? Just wondering.

Answer 5

I am having the same issue with strike throughs on manual formulas, the link above results in a page not found error for me. Is there another way I can find the solution?

I use manual formulas due to the large number of formulas and the cyclical nature of how the sheet works with changes, would have to wait far to long for one small change