Automatic Update of External Links

jepthon · October 17, 2021, 8:50pm

Cannot figure out how to get annoying “automatic update of external links has been disabled” to go away. I want my links to automatically update. On the verge of switching back to Excel for this spreadsheet.

version 7.1.6.2

Here is an example:

=VLOOKUP(B1,‘file:///Users/me/Library/Mobile Documents/com~apple~CloudDocs/Shared Office/customer list.ods’#$active.B2:G11484,6)

The help link given to me does not make it clear.

Hrbrgr · October 17, 2021, 8:55pm

On the verge of switching back to Excel for this spreadsheet.

And who do you want to inspire with that?

https://helponline.libreoffice.org/latest/en-GB/text/shared/01/02180000.html

jepthon · October 17, 2021, 9:36pm

One solution is to create the files in Excel and then open them in LibreOffice on the iPad but keep the xlsx format so that external linking works.

erAck · October 17, 2021, 10:22pm

Tell Calc that you trust files in a directory where you place the calling document (that contains the VLOOKUP) to open other files and read their data. For that,

go to Tools → Option → LibreOffice → Security, Macro Security, tab Trusted Sources
add a directory to trust files in; OK
then, still in the Options dialog, go to LibreOffice Calc → General, Update links when opening
select Always (from trusted locations); OK

jepthon · October 18, 2021, 2:06am

I appreciate your response, but in Calc version 7.1.6.2 for Mac I do not find Option under Tools. I can go to Preferences / LibreOffice Calc / General and under “Update links when opening” I have it selected as "Always (from trusted sources).

I still get the message “Automatic update of external links has been disabled”. I think it is a bug.

erAck · October 19, 2021, 2:27pm

Mac likes to do things different and calls Options Preferences and places them somewhere else.

If you already selected as "Always (from trusted sources)", did you also do the other step I lined out to actually add a trusted directory?