Page **1** of **1**

### ERR 509

Posted:

**Wed Feb 13, 2019 9:04 pm**
by **DPARK**

I have in the last couple of days updated to 4.1.6, now a spread sheet that I use for household stuff is showing err 509 in all the cells that have any kind of formula. I looked at the formula list and there is now nothing in it that there was before

### Re: ERR 509

Posted:

**Wed Feb 13, 2019 9:42 pm**
by **Zizi64**

From the help:

509 Missing operator

Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.

Please upload your sample file here.

### Re: ERR 509

Posted:

**Wed Feb 13, 2019 10:02 pm**
by **DPARK**

Ive just checked the Formula list again and there isn't anything showing in it. The list of all the different formula isn't there anymore. I click on a cell with a formula and the formula is there but showing err509.

### Re: ERR 509

Posted:

**Wed Feb 13, 2019 10:11 pm**
by **Zizi64**

Please show us at least the formula ...

### Re: ERR 509

Posted:

**Wed Feb 13, 2019 10:20 pm**
by **RusselB**

Also remember that the formula you are looking at might not have a mistake, but a formula that is referenced could have the mistake.... it can take a while to locate which formula has the error if you have a lot of formulas that reference other formulas.

### Re: ERR 509

Posted:

**Thu Feb 14, 2019 5:56 pm**
by **DPARK**

The formula are all simple stuff =sum() etc and have been working ok for quite a few years as ive had the spreadsheet a while. the problem occurred once I up graded to 4.1.6.

### Re: ERR 509

Posted:

**Thu Feb 14, 2019 7:01 pm**
by **RoryOF**

Please upload a small sample file so that we can analyse what may be wrong. Otherwise you are wasting your time and ours.

### Re: ERR 509

Posted:

**Thu Feb 14, 2019 7:18 pm**
by **DPARK**

Thank you for your time, I opened the file in another spreadsheet prog and all the formula work it is something to do with the update itself

### Re: ERR 509

Posted:

**Thu Feb 14, 2019 9:28 pm**
by **Zizi64**

=sum()

Your sample formula have not any parameters. What will be summarized?