How to get my formulas to Automatically calculate and update my totals once I enter a new value in a cell block. [closed]

asked 2018-10-02 05:21:31 +0200

liverlover gravatar image

updated 2018-10-02 10:28:46 +0200

ebot gravatar image

I am using calc in LO , and have entered my data in spreadsheet along with formulas for totalling columns and rows. I used it and all works UNTIL I change data in one of the cells. Then it does not automatically update the total. I have to go to the cell where the total is, and renter the formula and then it will work. How do I get it to automatically update my sums?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by ebot
close date 2018-10-03 09:19:03.685719

Comments

Please read the guidline. Which OS do you use? Which LibreOffice version do you use? Which file type (Extend) do you use?

ebot gravatar imageebot ( 2018-10-02 10:10:19 +0200 )edit

Data > Calculate > Autocalculate. Is Autocalculate checked?

gtomorrow gravatar imagegtomorrow ( 2018-10-02 23:29:06 +0200 )edit

Sorry. I use Windows 7 Professional, LO 6.1.0.3 file x-tension ".ods" I have been playing around with this program and managed to get it to work.... thanks though

liverlover gravatar imageliverlover ( 2018-10-03 03:07:34 +0200 )edit