I have two Libre Calc files and one has links from the other file. I have them set so the links update automatically when the second file (with the links) is open. However if both files are open and I make changes to the file target file, I have to update the second file manually. If there is a way to make the links update automatically any time the target file is updated (like Excel does) please tell me how.
Use the DDE function instead of external links.
Instead of
'file://path/document.ods'#Sheet.A1:B1000
DDE("soffice","C:\path\document.ods","Sheet.A1:B1000")
The external link stores a copy of the referenced data, so it works even if the referenced file is unavailable, whereas the DDE link loads the referenced file invisibly.
You get a DDE link “for free” if you drag a range from one document into the other and drop with Ctrl+Shift being pressed.
The file path of the DDE link is in system notation, whereas the external link uses an URL.
If the size of the referred range changes, you should define a named reference.
Instead of "Sheet.A1:B1000" use "Some_Range_Name". This will adjust automatically when you delete cells from the named range and when you insert cells into the named range, whereas "Sheet.A1:B1000" always remains the same reference.