Forum Discussion
Hyperlink changes excel online
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 w...
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=D3A1786FE63F549D!109&app=Word
Not Working
https://onedrive.live.com/edit.aspx?cid=d3a1786fe63f549d&page=view&resid=D3A1786FE63F549D!4616&parId=D3A1786FE63F549D!109&app=Word
- 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! 🙂