After adding my hotlink and selecting the row of figures, the figures are not pulling through to the record.

In the Excel spreadsheet you are hotlinking to, check that the R1C1 reference style is not ticked.

This is found in Files > Options > Formulas > Working with Formulas.

You may need to relink the hotlink.