This is a weird one. I built this worksheet myself from the ground up. It is based on a series of SUMIFS-formulas, but that is largely beside the point.
Consider worksheet "Input_other".
- cell D133 used to contain "-25.000". This value somehow got lost. I did not accidentally delete it by tagging more than one worksheet, or by any other means that I am aware of.
- cell F133 contains a single formula: "=D133/12"
- since D133 is empty, this should be 0. But it still shows as "-2.083" (which =25.000/12).
- and the whole spreadsheet calculates based on this false value.
Manipulations act weirdly, too:
- set to Manual refresh, and reresh manually (F9) ->Nothing changes
- refresh D133 (by pressing F2 -> Enter), and the whole worksheet refreshes.
- refresh F133, and only this cell refreshes, but not cells referring to F133
- set a filter, and the whole workdsheet refreshes
- delete or Group a number of rows -> the worksheet refreshes
- hide rows -> nothing happens
I was able to reproduce this in a colleagues PC.
What worries me most is the fact that cell content apparently gets lost for no reason at all. The fact that calculations then don't refresh is weird on top.
Has anyone seen something like this before? Does anyone know a solution or safeguard?
Cheers, Ben
Bookmarks