Ask Your Question
0

link to other files

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

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
0

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

Jim K gravatar image

Save as ODS format instead of XLS. Then go to Edit -> Links, as suggested at https://superuser.com/questions/38605....

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 https://ask.libreoffice.org/en/questi....

edit flag offensive delete link more

Comments

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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 25 times

Last updated: Jan 12