I did a search, but couldn't find an answer

I used a Hyperlink to bring up a snip of the images that were large and/or couldn't embed in the excel cell, this helps you see the image when editing the questions database.

BUT, when we do the random test generation and the VLookUp formula brings the corresponding question over to the randomly generated test page, the Hyperlink goes away. The click for image is still there, but nothing happens, the hyperlink to the image is gone. Any ways to fix this?

Appraisal Test 9-14-2022.xlsm