please excuse me if I use the wrong technical terminology. I use LO Calc to keep my accounts for my small business. as a sole trader, I only need to run a Profit and Loss sheet, so I dont use a full blown accounts package.
I have several ‘sheets’ (?) in my spreadsheet; i.e. Invoices, Current AC, Cash, etc… and a front sheet for a summary.
on the summary sheet, I have two columns; a description, and a ‘pointer’ to a cell on the other sheets, for example;
Total Invoices Paid =Invoices.F63
Total Invoices Due =Invoices.G64
Cash In =Cash.C61
Cash Out =Cash.B61
Current Account Balance =CurrentAC.F334
I also have similar ‘pointers’ on other sheets, referencing cells on other sheets, and incorporating them into calculations etc…
my problem is this - for some reason, I have no idea what, I will notice that the cells on my summary sheet are completely wrong, and will typically return £0.00 or #VALUE! or whatever… on closer inspection, the example given above will have turned into this;
Total Invoices Paid =F63
Total Invoices Due =G64
Cash In =C61
Cash Out =B61
Current Account Balance =F334
… and I have to plough through all my sheets working out which cells have spontaneously lost the pointer to the other sheets, and re-enter it all manually…
this alarms me somewhat, as I completely rely on this spreadsheet to keep my business running, and I am feeling that I cannot trust LO to do its job!!
can anyone please shed some light onto why or how this is happening and how I can prevent it ever happening again??
many thanks in advance.
For conservative use I’d recommend 4.3.x Still, currently 4.3.5 and soon to be released 4.3.6