I’m excited to announce a significant improvement to one of spreadsheeting's oldest features - Manual calculation mode. Manual calculation mode debuted in VisiCalc in 1979 (44 years ago), 6 years bef...
I found this option irritating and immediately looked for a way to disable it.
I do not have the apparent option to disable it under "Calculation Options," but I found out that clicking the yellow triangle on a specific cell allows me to disable it for all other cells.
I found it irritating because I use Strikethough for other mechanisms in my models.
I cannot differentiate between my own and Excel's auto strikethrough, so I must disable it.
I concur that this might be a good option for others who forget to update their formulas manually (I cannot auto-calculate because every calculation takes around 1 minute), but a different approach should be considered.
I thought of the other options others proposed here, but every visible signal on a cell might be something someone uses already as part of "Conditional Formatting" or any other auto-marking (including font bolding/background/foreground colors and more), so I propose to point out with a yellow ribbon at the top, the same as with uneditable document or other notices that excel puts on file permissions/attributes, etc.
I was just so delighted when Excel started doing this. It made my day. I thought, "How is it possible that I've been using Excel for at least 40 years, always on manual recalculate, and survived without it?"
Then, I immediately turned it off and cursed Bill Gates for the 50 millionth time.
I rather like the strike-through of stale data for a different reason. In the 25 years I have used Excel (prior to that I would write a program on a mainframe computer), I have never intentionally used calculation manual. On occasion I have received workbooks set to such a mode and the immediate reaction is to consider reinstalling Excel! Now I at least get some warning that all is not as I may think.