I have a hyperlink in a cell on a tab in Excel. You click it, it opens the link. I have three other tabs that reference that cell. The hyperlink appears in these other cells. But, if you click on them, the hyperlink doesn't work.



But, in other similar workbooks, this same situation ends with the hyperlinks working. I cannot see any formatting differences between the cells that work and the cells that don't.

Any ideas on how to make them all work? Or, what should I be looking for that some work and some don't?

Thank you in advance for your time and assistance.