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

[liverlover]

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?

[Hrbrgr]

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

[gtomorrow]

Data > Calculate > Autocalculate. Is Autocalculate checked?

[liverlover]

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