Web hyperlink not working in Excel

[TB2023]

Hi, I wonder if anyone can shed some light on the problem that I'm having with Excel (using free version of Microsoft 365, with workbook stored on OneDrive).

I paste a web URL into Excel, and web link works fine (the Link Text is displayed in the cell)

But when I return to the Excel document next day, the link text is still displayed, but the link does not work. I have to paste the web URL into Excel again, for it to work.

Is there a specific format for Web links that I need to set?

[#2]

what format is the file? For example if it is a .csv file it won't work. Is it an .xlsx (or xlsm or xlsb)?