Hyperlink

3 Topics

Hyperlink returns "Your organization policies are preventing us from completing this action"
I'm trying to create hyperlinks in an Excel file linking it with another sheet in the same file and tried to do many hyperlinks in other files and it keeps showing me this message.
AyaDiab
Oct 19, 2019 Place Excel
41KViews
0likes
1Comment
Cannot concatenate a hyperlink from another cell
I am working with office 365 and I have done this in previous versions but its not working now. I have a site with a html pages like 1.html, 2, html etc. If I write in a cell http://www.mysite.com/1.html the link works fine if I have a list of numbers in column a and column be is any of the following: ="http://www.mysite.com/" & a2 & ".html" =hyperlink("http://www.mysite.com/" & a2 & ".html",a2) =hyperlink("http://www.mysite.com/" & indirect("a2") &".html",a2) The link is not formed properly. Even in the case of the first if I copy and paste values the spreadsheet shows http://www.mysite.com/1.html but when I click on it I get an error "cannot connect to http://www.mysite.com/a2.html Is this a bug or am I missing something. Haim Katz
Solved
h-i-k
Mar 24, 2019 Place Excel
8.2KViews
0likes
4Comments
Excel Hyperlink and Vlookup
Hello, I have a hyperlink on one tab of a workbook. I need the link to copy to another page based on a key identifier. I have been using vlookup to move data to the front page for the rest of the fields, but the hyperlink has me stumped! =VLOOKUP($C121,'Projected Wires'!$A:$R,18,FALSE) returns the link text...ish.
accounting
Oct 15, 2018 Place Excel
814Views
0likes
0Comments