Forum Discussion
Sheet not Calculating
Hi everyone, We have a rather large file which when we go to make changes we often find formulas are returning as 0 (or -) when this is not possible. Even when connecting to a different cell (=C12)...
What are your current calculation settings?
Does it help to press Control+Shift+Alt+F9 ?
Does it help to press Control+Shift+Alt+F9 ?
I have it on automatic calculation. I tried to calculate sheet which I believe is that F9 function however the only way I could get them to be correct is changing to Manual calculation and going through each Cell and recalculating