Ask Your Question

link to other files

asked 2018-01-12 13:15:21 +0100

uffe_K gravatar image

When I open a spreadsheet (XLS-format), I get the message "This file contains link to other files. Should they be updated?". Issue is there shouldn't be any links, so how to find why Calc thinks there is one?

I have just moved from Office2000 to LibreOffice, looks good so far.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-01-12 15:33:49 +0100

Jim K gravatar image

Save as ODS format instead of XLS. Then go to Edit -> Links, as suggested at

A typical file link in Calc looks like ='file:///path/to/spreadsheet.ods'#$Sheet1.A1, so it may also work to go to Edit -> Find and search for #.

A similar question is

edit flag offensive delete link more


Saving as ODS helped, searching for # or file didn't help - had already tried that.

uffe_K gravatar imageuffe_K ( 2018-01-12 17:31:35 +0100 )edit

Glad to hear it worked. Regarding "had already tried that" - it would have been better to include that information in the question. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-13 17:55:34 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-12 13:15:21 +0100

Seen: 13 times

Last updated: Jan 12