3 ms·
I've had columns filled with a formula and intentionally replaced one cell with a static value. You immediately get a warning on that cell that can be ignored/c
by pc86 3y ago
I've had columns filled with a formula and intentionally replaced one cell with a static value. You immediately get a warning on that cell that can be ignored/cleared but takes a handful of clicks to do so. Granted, there's no overall place to view the warnings (that I am aware of) so if you have 100k lines and one cell replaced you can't easily see it without inspecting everything. Is this no longer the case?
- theshrike79 3y agoI just made an Excel sheet, put in formulas and I could just type over any formula with numbers without any notifications or errors. How do you manage to require "a handful of clicks" to do it?
- mkishi 3y agoThis only happens in "proper" tables. When you add a formula to a table column, Excel will automatically convert it into a "calculated column," so overridden values will have a green mark denoting an "inconsistent formula." It's still a pretty minor warning and it only requires two clicks to ignore.