How To Update Referenced Data From Another Workbook Automatically

Question

I've referenced data from an external workbook source in LibreOffice Calc (v 24.8.0.3 on Win 11) and while the referencing successfully populates the target workbook, it does not dynamically update the information when the external information updates.

='file:///C:/Commodities.ods'#$CommodityList.A2 (full URL redacted for security purposes)

is the formula used to retrieve external workbook data.

The results of the data pulled is shown below in the image.

Column H is the referenced data and it successfully populates the necessary cells.

Cols D, E, and F are images that are assigned to each unique label (Jewelry, Timber etc) for inventory purposes based on items currently in stock pulled from a simple list not shown here. They are not directly used in col H in any formula. Col H is used to test against for assigning the markers in D, E, and F. These columns dynamically update when this data is updated on a different worksheet and they work without issue.

The problem I'm facing is Col H not updating dynamically as the other workbook sheet data is updated (which is every time it's recalculated either manually or using timed intervals (Name Range). It only updates if I've actively selected the cell (in this case H2 labeled Jewelry) and force re-calculation using F9. If the cells are not actively selected nothing happens. Also, I have to manually select H2 and drag the selection to H6 to force the data to update.

How to I accomplish this so this information is updated automatically when the target workbook (in this case the one showing the makers) is opened?

SUMPRODUCT would be useful here but I'm not trying to combine products to obtain a sum. I'm simply trying to get col H to dynamically update as the other workbook updates.