Calc Update data links with macro

[calvin17]

LibreOffice 6.4 and older calc document links could be updated in a macro using “uno:UpdateTableLinks”.

That no longer works in LibreOffice_7.0.5_Win_x64.

Is there a work around to refresh all links via a macro?
Do charts now update when link data is refreshed?

[erAck]

Make sure it’s .uno:UpdateTableLinks, note leading dot.

[calvin17]

Found a fix loading the current Libre Calc 7.0.6.2 winx64 version.

1. sub Update_single_link
2. dim sURL As String 'URL of previously linked data file
3. dim oLink As Object 'The link object
4. sURL = “file:///C:/My_Dir/my_linked_data_ file.csv”
5. oLink = ThisComponent.SheetLinks.getByName(sURL)
6. oLink.refresh()
7. End Sub

And – so far - charts update when new data is loaded running the current LibreOffice version 7.0.6.2