Forum Discussion
Losing Hyperlinks in Office 365 and OneDrive
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 usingJKPieterse Hi Jan, I have attached 3 screenshots. 1st one is the test spreadsheet image, showing the icon placement and the text box within it that is holding the hyperlink. 2nd one is the link formula. 3rd one is the second spreadsheet in the workbook showing the cell that the link points to. This is in Excel 2016 (non-cloud version). As I mentioned before, when trying to work with this setup in Office 365, the hyperlink completely disappears and there is no functionality to add one back.
It is important that the unusual placement of the icons/text boxes remain this way, as I am trying to emulate a floor layout of a department here. I've tried to accomplish this in Word and Visio as well, but keep running into roadblocks. I hope this explains the situation more fully. As always, I appreciate your input on this. Thank you!
- Have you tried using the "Place in this document" category to create the link?
