Created attachment 100141 [details]
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 - err.509 replaces previously correctly displayed data.
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...
*** This bug has been marked as a duplicate of bug 45286 ***