Validity list results in error 520

Discuss the spreadsheet application

Validity list results in error 520

Postby Waldo120 » Sun Jul 27, 2008 11:27 am

Hi, I'm trying to make a drop down menu using a list in another sheet in the same file. And I do, quite well using Data - Validity - Cell Range. However, once I close, save, and reopen this document my drop down now says Err:520. What gives? According to the help file 520 is "compiler creates an unknown compiler code"

I should note that:
1. This file is on a network drive.
2. I am trying to create a whole column of drop downs to the same Cell Range, but I get this even when I only do one drop down cell.
3. This is saved in excel XP format.

Win XP, Ooo 2.4.1
Calorie Count.xls
(74.5 KiB) Downloaded 140 times
User avatar
Posts: 31
Joined: Sun Jul 27, 2008 11:16 am

Re: Validity list results in error 520

Postby squenson » Sun Jul 27, 2008 11:44 am

I guess that saving in Excel format is the root cause of the problem. Try saving in native OOo format (.ods) and let us know the result.
LibreOffice on Ubuntu 14.04
User avatar
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Validity list results in error 520

Postby TheGurkha » Sun Jul 27, 2008 11:53 am

Hi and welcome to the forums.

I took your file and modded it so that there was enough data in the Food List eto allow the menu to have data in it in the Monday sheet. Got it working by using the Data > Validity > Cell Range sequence as you did, supplying 'Food List'.$A2:$A19 as the cell range. It works in, saved it as a new .xls and it didn't work when re-opened, so it would appear it has nothing to do with a network drive.

I opened the original file and re-did the above, saved it as .odt, opened it again and it worked fine. Until recently the .xls and .doc formats were proprietary secrets, and the OOo developers had to reverse engineer them. I think you have either stumbled something that isn't supported by .xls or that OOo does't save correctly for the .xls file format.

(PS. 'Summery' means like the Summer, I think you meant 'Summary' ;) )

If your question has been answered please go to your first post, use the edit button and add [Solved] as the first word of the title. You can also select the green tick icon.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version:
Gurkha Welfare Trust
User avatar
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Validity list results in error 520

Postby fst » Wed Jul 30, 2008 11:22 am


this can't work with XLS files because Excel isn't capable to use references to other sheets in Data-Validation-List or any other Validation feature.

So you have to use either the ODS file format or have to place the source for the list on the same sheet.


If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 152
Joined: Wed Nov 28, 2007 2:31 pm

Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests