I have a table in an Excel sheet where one column is calculated. When adding a new row by typing, the table automatically expands, but wrongly changes the formula of that column in the row above. It then marks the cell with a green triangle and offers me to 'Restore to Calculated Column Formula'.
How can I stop Excel from changing the formula like that?
In case it matters, this is the formula in cell M15. The data starts at row 12. It's function is to show a day total next to the last entry for that day. If required I can upload a sample sheet, but I'd have to remove sensitive data first. When I add a new entry in row 16,
L15 changes to
L16 in both the new entry and the previous entry.