Hyperlink changes excel online

Copper Contributor

When i make a hyperlink to another site, excel online changes and put in amp; in the middle

the link goes to the site but wrong page.

 

Microsoft did check in the computer and said its something wrong in Excel online..

It have worked perfect for 5 years but YESTERDAY 21/10-21 this show up..

 

See red line what excel makes the link is saved..

3 Replies

@flyttar 

 

We have the exact same problem - if the spreadsheet is opened in desktop excel, it is fine.

If opened in online excel 'amp:' is added several times in each hyperlink.

Edit the hyperlink in online Excel and the 'amp:' is automatically added back

 

Example:-

Working
https://onedrive.live.com/edit.aspx?cid=d3a1786fe63f549d&page=view&resid=D3A1786FE63F549D!4616&parId...

Not Working
https://onedrive.live.com/edit.aspx?cid=d3a1786fe63f549d&page=view&resid=D3A1786FE63F549D!46...

Seems clear it's an online Excel bug as the links have been working fine for 18 months here.
Couple of workarounds:-

1) Copy the hyperlink cell to a online Word document - it will open OK there with a CTRL-Click
2) Upload the spreadsheet to Google Sheet and the hyerperlinks open OK
As of today, hyperlinks have started working again without us changing anything! :)