Err.509 referencing cells in external excel book [closed]

asked 2014-05-29 07:28:00 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

LibreOffice: Version: Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24

Windows 7 Service Pack 1, Australian

I have created a sheet that references cells from many external work books. On creation it displayed values as expected. On re-opening all values now read Err.509 Have read other possible answers to problem but none provide solution - Err.509 all the way. Surprisingly the column of Sums that sum the values across the row still displays the correct figure.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-23 21:51:00.303745


OK moving right along: When I create the reference it looks like this: ='file:///c:/users/andrew/documents/shinju 2014/treasurer/myob2014/murakami2014_050514.xlsx'#$'The sheet'.$C$4 I save the book Using XLSX format (I have to work with excel people) I now close the sheet. I re-open the sheet - old err.509 is back and this is what the cell now reads as the reference: =['file:///c:/users/andrew/documents/shinju 2014/treasurer/myob2014/murakami2014_050514.xlsx']'the sheet'!$c$4 So somewhere in the saving and re-opening phase we have acquired a set of square brackets, lost a # and $ and exchanged a . for a ! Result equals useless....

votedave gravatar imagevotedave ( 2014-05-29 07:48:58 +0100 )edit