Forum Discussion
Losing Hyperlinks in Office 365 and OneDrive
Hello, first-time poster here. I hope someone can help with a dilemma I'm experiencing. I have an Excel 2016 workbook which contains 2 worksheets. The first worksheet consists of icons I inserted. I wanted the icons so that I could rotate them to suit my needs. Within the icons, I created a text box and inserted a hyperlink in each one that referred to a specific cell in the 2nd worksheet. In regular Excel, the links work great. However, when trying to test/edit in Office 365 or OneDrive, I find that all of the hyperlinks have disappeared, as well as the ability to create any new ones. This has really stumped me. Does anyone have any suggestions? Many thanks! 🙂
7 Replies
- Does it work if you use the HYPERLINK function in a regular cell? Use it like so:
Suppose cell A1 contains the name of a worksheet, then enter this formula in another cell (note the # and the single quote characters!):
=HYPERLINK("#'"&A1&"'!A1","Click here")JKPieterse Ok, I opened up the spreadsheet in Office 365 and pasted your link example in a cell. It did appear as a link with the text Click here as the name of the link. I received an error referring to either an invalid link address, or a permissions issue. I've attached the message for you. This may very well be a permissions issue, unless I did not use your example correctly. What do you think? Thanks for your help with this!
- Can you post:
- The exact HYPERLINK formula
- The content of the cell that formula is using
