### Calc- problem linking to data in another spreadsheet.

I have a spreadsheet that links to specific cells in many other spreadsheets by cell names so that if the cell position changes the data will still be valid. With Libreoffice 4.2.0.4 and Windows 7, the formula or link appears rather than the data from the other spreadsheet.

In spreadsheet 1.ods Cell a1=2, Cell a2=3, and Cell a3=sum(a1:a2) and I've named it CellA3.

With “Insert from External Data” in spreadsheet 2.ods, the formula, =SUM(A#REF!:A#REF!), from CellA3 appears rather than the data.

Using Hyperlink the link appears and Crtl click takes me to spreadsheet 1.ods rather inserting the data from that cell.