Some hyperlinks not working within workbook

Hi there

I have created a huge workbook with multiple tabs. The first tab is a directory listing all the recipes with links to their tabs and other info in a table.

The file is opened by different users, mainly on office for PCs but I am accessing it from a Mac. It has been opened a number of times by people with limited excel skills since I first created it. From either a PC or MAC some of the hyperlinks have stopped working.

I have tried all the below to restore the hyperlinks to different sheets with no avail

Cleared the formatting of the cell with the broken hyperlink, and tried adding a link again
Tried creating a link in another cell and copying and pasting it
Tried copying a link that is working and attempted to change it

With all the above the display text shows but when you click it there is no link

I am an intermediate user of Excel who hasn't as yet tried their hands at Macros so would be grateful for any suggestions suitable for me.

Thanks in advance!

Attach you spreedsheet