Description:
When the HYPERLINK function calculates (has some nested function(s)) a hyperlink to another cell and that calculation results in #N/A the hyperlink breaks completely even if the calculation changes to a valid link due to changes external to the HYPERLINK() cell. Recovery requires re-edit of cell (F2,Space,Enter) or reload of the document. Recalculate/Hard recalculate do not avert the issue [nor does adding a recalculation trigger such as &T(RAND()*0)].

Steps to Reproduce:
1. Insert into A1: =HYPERLINK(ADDRESS(B1,C1))
2. Insert into B1: 1
3. Insert into B2: 2
4. Recalculate (F9) as needed since using indirect reference.
5. Hyperlink works as expected, to B1
6. Now insert into B2: =MATCH(-1,{1},1) //Or other throw of #N/A
7. Hyperlink shows #N/A

Actual Results:
8. Ctrl-click on hyperlink acts as 'normal' Ctrl-click multi-select instead of hyperlink
9. Hyperlink is unusable
10. Other hyperlinks in document continue to work
11. Reverting B2 to original (Ctrl-z) value will not reactivate hyperlink, nor will any valid value

Expected Results:
Expectation would be for the HYPERLINK() function to recover from the #N/A once B2 was reverted back to a valid argument for ADDRESS().


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Thanks to Villeroy for double-checking and creating the original spreadsheet that pointed out this oddity.