Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

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.