I need to auto calculate a column of figures. I tried to use “auto calculate” under tools and was unsuccessful.
Put a checkmark in the menu Data>Calculate>Calculate automatically
.
You can manually generate a calculation with F9
.
I tried this method and it still doesn’t work.
Then please post/upload your file for inspection.
.
Your column is never calculated?
Or not recalculated after changes in related cells?
Updates of external data not recognised?
Or are we on the topic of iterations?
…