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) it returns -.
To start with we were able to use the calculate sheet/workbook function but now not even that is working and sometimes that can make other random cells also return -.
The only way I can change is if I change calculations to manual.
Is there a way to fix this? Thanks.
2 Replies
- What are your current calculation settings?
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
