Ask Your Question
0

.xlsx link not working

asked 2017-12-05 16:49:56 +0100

Andy Ward gravatar image

I am setting up a spreadsheet with links to other spreadsheets and the links I have created are not updating. When I open the file I get a message "This file contains links to other files. Should they be updated Yes or No?" I answer Yes but the link does not update. I am using LibreOffice Vanilla V5.4.4.3 on a MacBook Pro 2017 using iOS High Sierra.

Any advice?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-12-06 11:34:53 +0100

Andy Ward gravatar image

Thanks Jim K. Saving as an odf file instead of a xlsx file seems to have solved this

edit flag offensive delete link more

Comments

This is not an answer, so it should be moved to a comment on the other answer instead. Also, it sounds like the matter is resolved, so please click ✔ to mark an answer as correct.

Jim K gravatar imageJim K ( 2017-12-06 15:26:22 +0100 )edit
0

answered 2017-12-05 18:07:01 +0100

Jim K gravatar image

From testing this on my system (Win10 LO 5.4.0.3), it seems .xlsx link updating is rather buggy.

Under certain circumstances, it gives an error message, "The following external file could not be loaded. Data linked from this file did not get updated." Other times, it gives no error but does not update. It may also destroy the formula. Sometimes everything works correctly.

Selecting the cell and going to Data -> Calculate -> Recalculate (F9) may help. Also, it works better when both files are open.

My suggestion: Do not use links to other spreadsheets unless you are willing to use .ods format. I encountered no problems this way, whether the other file was open or not.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-05 16:49:56 +0100

Seen: 18 times

Last updated: Dec 06