Ask Your Question

How do I make formulas automatically recalculate?

asked 2017-09-24 06:58:34 +0200

rkkn gravatar image

Last time I used this software (long time ago), that happened by default. Now I have to F9 every time.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-09-24 07:46:21 +0200

robleyd gravatar image

updated 2017-09-24 09:30:10 +0200

Look at Tools | Cell Content and ensure that AutoCalculate is checked.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

Edit: Apparently LO now has it under under Data | Calculate | AutoCalculate - see

edit flag offensive delete link more


Where is Cell Content?

also it may have just been a bug. restarting my computer fixed it, it seems?

rkkn gravatar imagerkkn ( 2017-09-24 08:53:16 +0200 )edit

Depends on the version, look in Menu/Data/Calculate

m.a.riosv gravatar imagem.a.riosv ( 2017-09-24 13:11:03 +0200 )edit

answered 2019-01-02 21:13:48 +0200

Not an answer but a confirmation that no Ctrl Shft F9 variant works to update a few formulas on different lines.

The entire sheet was formed solely in Calc but I have no apparent means of updating anything with Randbetween in a formula unless it's just one cell and I use F9. Any help appreciated.

edit flag offensive delete link more

answered 2018-11-10 11:05:52 +0200

Under Tools > Options > LibreOffice Calc > Formula

You need to re-enable Recalculation on File Load. (Probably for Excel 2007 and newer) Set it to Always recalculate. Then you'll get the behaviour you're after.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-24 06:58:34 +0200

Seen: 2,913 times

Last updated: Jan 02