OK, the attached is what I get when I copy part of the problem spreadsheet and paste it into a new workbook, but it does not show the problem as I had it, in that changing the entry in D9 does not change E9 as it should, whereas in the original that did change to the correct figure, but the Total shown in E16 did not change.
This is why I didn't post it in the first place, but if by any chance it helps, it's now here. If there's a better way to copy please let me know.
The formulae will not show here, but they look perfectly OK in the malfunctioning original.
|