Ask Your Question

Link to External Data xls NOT [closed]

asked 2019-06-14 09:04:03 +0200

dbird gravatar image

Have a calc libreoffice spreadsheet (.ods). One sheet links to an external file of type .cvs. Another sheet links to another external file of type .xlsx. This spreadsheet has worked for over a year, but now has stopped loading the .xlsx file, showing the error "The link could not be updated."

This behavior first showed up when I updated from to 6.1.6, so I uninstalled 6.1.6, and reinstalled There was no change.

I made a simple Untitled 1.xlsx file, written by libreoffice calc (Untitled 1.ods), and tried to link one of the .ods sheets to the Untitled 1.xlsx file. No joy. The OK button is grayed out. It will link a cvs file just fine.

What's going on?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-06-18 12:52:26.094311

1 Answer

Sort by » oldest newest most voted

answered 2019-06-14 15:12:09 +0200

erAck gravatar image

Spreadsheet documents linked to need a defined named range to link to of which the data is to be imported. If there are no named ranges the dialog can't be completed (6.3 will have a message saying so). For CSV that is not necessary as there is only one range/table. Likely when updating stopped working the external spreadsheet file had the remembered range removed. You can check under menu Edit -> Links to External Files... what Element the link points to.

edit flag offensive delete link more


Thanks for the reply. What does this named range look like? How would I modify the .xlsx spreadsheet that I saved as a test, so that it will load correctly?

dbird gravatar imagedbird ( 2019-06-15 08:57:28 +0200 )edit

Any named range defined under Sheet -> Named Ranges or Expressions -> Define... (or Manage, Ctrl+F3) will do.

erAck gravatar imageerAck ( 2019-06-17 13:15:19 +0200 )edit

Thanks. Did that. It works for my Untitled sheets. Case closed. Thanks again.

dbird gravatar imagedbird ( 2019-06-18 02:56:49 +0200 )edit

Question Tools

1 follower


Asked: 2019-06-14 09:04:03 +0200

Seen: 28 times

Last updated: Jun 14