These spreadsheets were created with LibreOffice 5.4.3.2 and LibreOffice Dev. 6.0 and contain links. If we want to refer to an external file with cell reference or a function, we have to click in the function to refresh the links. If we just open the file and click Yes on the “This file contains links to other files. Should they be updated?” message, nothing happens.

Steps to reproduce:
1. Create a new spreadsheet with LibreOffice Calc.
2. Click on Tools then choose Options.
3. In the Options set the LibreOffice Calc Formula options just like as you can see at the attached Formula_syntax_setting.PNG file. I use these settings because this is the only one which is interoperable with Microsoft Office Excel.
4. Fill the cells with some simple data.
5. Save the file as “Source.xlsx”. This will be the source file which contains the queried data.
6. Create a new spreadsheet in Calc and save as Function-update-link-target_LO-54.xlsx. This is the reference file.
7. In the Function-update-link-target_LO-54.xlsx file create a correct function or a simple cell reference which refers to the “Source file” data.
8. Save the file and close it.
9. Modify the “Source.xlsx” file data, which is referenced by the reference file.
10. Save the file.
11. Open the reference file (Function-update-link-target_LO-54.xlsx) and click YES on the  “Should they be updated?” message.

Actual results:
When I click YES on the “Should they be updated?” dialog, nothing happened. If I choose  the “Always” Update links when opening, instead of “On request” I still get the dialog.

Expected results:
When I click YES on the “Should they be updated?” dialog, the links should be updated. If I choose the “Always” Update links when opening, instead of “On request” the links should be updated automatically without any message.


Version: 5.4.3.2
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
CPU threads: 4; OS: Windows 6.1; UI render: default; 
Locale: hu-HU (hu_HU); Calc: group

Version: 6.0.0.0.beta1+
Build ID: 29228e83df009cf76ac819ed024527be1092f065
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-04_23:15:34
Locale: hu-HU (hu_HU); Calc: group threaded