Hyperlinks with different display text won't work in PDF

If I use 'text to display', when I save and/or print the Excel file as a PDF, the link won't work. 

I'm going crazy trying to figure out how my predecessor accomplished this task!