What does Err:520 mean in a cell? [closed]

asked 2014-03-15 19:48:04 +0100

mreky2
3 ●3 ●3 ●5

updated 2015-09-10 14:45:23 +0100

flag of United Kingdom of Great Britain and Northern Ireland

10514 ●14 ●42 ●42 http://etmg.altervista...

I have a spreadsheet that links to an external spreadsheet. It worked fine in 4.1 and earlier. However, in 4.2.0-2 one cell, linking to a cell on a specific page in another sheet, fails with 'Err:520' if the other sheet is not open at the time the first sheet's links are updated. Several other cells in the first sheet link to other pages in the external sheet and work correctly. There are no apparent errors in the other sheet, and the link is created by copying the cell in the external sheet, then using Edit-Paste Special-Create Link as for all the others that work. The update works correctly with no other changes if the external sheet is also open in LO at the time of the update. Very annoying - it's time to downgrade back to 4.1.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:02:59.168775

add a comment

Comments

This formula works: {='file:///C:/Users/Mike/Documents/Budget/mjbbooks2014/stocks14.ods'#$CVX.G2}

This formula does not: {='file:///C:/Users/Mike/Documents/Budget/mjbbooks2014/stocks14.ods'#$IBM.G2}

Formulae are in adjacent cells, linking to pages in the external file. The 'IBM' link works if the stocks14 file is open.

In the stocks14 file, the cell linked by the formula is a sum of a column on the page, such as: =SUM(E12:E201). There are no obvious errors in the column. Now is in 4.1 too.

mreky2 ( 2014-03-17 05:37:30 +0100 )edit

add a comment

What does Err:520 mean in a cell? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:02:59.168775

1 Answer

Comments

Question Tools

Stats

Related questions

What does Err:520 mean in a cell? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-20 08:02:59.168775

1 Answer

Comments

Question Tools

Stats

Related questions

What does Err:520 mean in a cell? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:02:59.168775