Web hyperlink not working in Excel

Copper Contributor

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?

1 Reply
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)?