Have you tried uninstalling AOO, downloadong it again from http://www.openoffice.org/download/ and reinstalling? Chances are that if this error was a bug, other people would have reported it. So be sure you have the complete downlaod and installation running first. Back up any files first just to be sure they are safe and secure, uninstall AOO, download 4.01 from the AOO web site and install it. Open the files and see if the problem is still there. If it is send me a copy of a file and I can check it works here. If it does it is definitely something peculiar about your system set up if not you found a bug that needs to be fixed.
On 20 October 2013 13:21, Michael Cleary <ringolum...@yahoo.co.uk> wrote: > Hiya, > Have looked at the link and I'm sorry but just not able to sort this out. > As I said, I'm not an expert and do not follow most of the terminology. > That said, I'm most grateful to you guys for taking the time to help, > thanks. Guess I'd better just get the pencil sharpener out. > Thanks once again, > > Mike > > > > On Sunday, 20 October 2013, 13:09, Rory O'Farrell <ofarr...@iol.ie> wrote: > > On Sun, 20 Oct 2013 11:03:07 +0100 (BST) > > Michael Cleary <ringolum...@yahoo.co.uk> wrote: > > > Good morning, > > > > As I was invited to upgrade to version 4.1, I did so. I am not a > computer expert and struggle with the formulae on my homemade banking > spread sheets but as they were functioning perfectly well before and now > every cell shows an error 509. > > > > I have spent 2 hours this morning which I really can't afford, and I > know I should try harder but frustration (and bad temper) is setting in, so > can you please advise me as to what has caused (and the remedy please) > these very simple formulae to now be incorrect as they were previously > fine. They are very basic arithmetic formulae, nothing complex at all. > > > > Sorry to be a pain, > > > > Very frustrated, > > > > Mike Cleary > > If this is happening with all formulae it is worth trying the universal > (first case) OpenOffice cure for oddities, namely to delete or rename the > User Profile > http://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426 > > -- > Rory O'Farrell <ofarr...@iol.ie > > > -- Ian Ofqual Accredited IT Qualifications <https://theingots.org/community/faq#7.0> Headline points in the 2014 and 2015 school league tables www.theINGOTs.org +44 (0)1827 305940 The Learning Machine Limited, Reg Office, Unit 4D Gagarin, Lichfield Road Industrial Estate, Tamworth, Staffordshire, B79 7GN. Reg No: 05560797, Registered in England and Wales.
