I've got a spreadsheet generating a list of urls. When I've completed the list I update one of the inputs (B2) and the list of urls is reset.

It all works well in theory.

=HYPERLINK($A$1 & B2,"Page " & B2)
The label, Page 204 (for example) is updated but the actual hyperlink isn't.

How do I convince Excel to actually update the link?