Mar 24 2019 12:09 AM
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 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:
="www.mysite.com/" & a2 & ".html"
=hyperlink("www.mysite.com/" & a2 & ".html",a2)
=hyperlink("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 www.mysite.com/1.html
but when I click on it I get an error "cannot connect to www.mysite.com/a2.html
Is this a bug or am I missing something.
Haim Katz
Mar 24 2019 07:40 AM
SolutionHi @h-i-k ;
I have tried your topic.
You must add http: // or https: // before the link
Like this :
=hyperlink("http://www.mysite.com/" & indirect("a2") &".html",a2)
You will find the file attachments the file that I created
Mar 24 2019 07:58 AM
Thanks @AbdallahBeraida. I thought I had tried that also but I see it works, so I guess I didn't.
Apr 03 2019 12:07 PM
@AbdallahBeraidaI am having a problem and ask for help:
In a spread sheet I have a column H filled in with links, I made them active by hyperlink function, and when trying to use it - every link sends me to the cell A1, i.e. doesn't work. I tried to set proper configuration in the Edit Hyperlink, nothing works.
Which I find strange as I have been using hyperlinks for many years, and they were always easily activated and working.. any idea?
thanks
Apr 03 2019 12:08 PM
Mar 24 2019 07:40 AM
SolutionHi @h-i-k ;
I have tried your topic.
You must add http: // or https: // before the link
Like this :
=hyperlink("http://www.mysite.com/" & indirect("a2") &".html",a2)
You will find the file attachments the file that I created