Excel hyperlink formula returns #VALUE! when opened in Teams but works when opened on desktop app

Hi,   For some users (5 employees) a hyperlink formula shows as #VALUE! when they open the Excel spread sheet in Teams. It works if they open it in the desktop app.   Is this a Teams or Excel iss...