A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Go to Formulas > Calculation Options > untick Format Stale Values
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Go to Formulas > Calculation Options > untick Format Stale Values
I think the blog post linked to below answers your question :)
https://techcommunity.microsoft.com/t5/excel-blog/stale-value-formatting/ba-p/3887098
If your computer isn't very old and slow or have extremely complex formulas, why would you "always use manual calculation"? Just wondering.
Thank you! That was it.