I have a spreadsheet in which some cells are linked to another document for the automatic retrieval of data. Everything works fine, but when I open the spreadsheet, I am always asked to enter the password for the document from which the data is retrieved. In the hope of avoiding this, I did the following:
- Tools > Options > LibreOffice Calc > General
- Look for update links when opening
- Always (from trusted locations)
and
- Tools > Options
- LibreOffice → Security
- Macro Security
- Trusted Sources
- Trusted File Locations → Add
- Add the folder where your spreadsheets are stored
However, I am still prompted for the password of the other document when opening my spreadsheet. What am I missing?