My spreadsheet has subtotals which are then summed in a cell, Total Spend. Pretty standard fare.
However, recently the Total Spend cell is not auto-updating when a change is made to one of the sub totals. I have checked formatting and Auto Calculate is ticked. Any ideas what I else can check?
I’m using LO 24.8.3.2 (X86_64) on a Mac OS 10.15.7
Please upload an ODF type sample file here.
Thank you for responding. I have prepared an example but have just discovered the problem, which lay in my formulae. I had one cell which was compensating for any amount I added to / subtracted from another cell and consequently the overall total remained unchanged. Sounds simple to spot but I’d been on this for hours 
.