2

I created a Google Sheets, included a link within it (using the "hyperlink" function) and then published the file to the web. It turns out that when you access it from the web, links don't work. Nothing happens.

3
  • 1
    Why don't you share a doc with us, so that we can have a look?
    – Jacob Jan
    Commented Feb 21, 2014 at 22:03
  • @JacobJanTuinstra please: docs.google.com/spreadsheets/d/… thanks :)
    – Optimesh
    Commented Feb 22, 2014 at 7:08
  • @JacobJanTuinstra, the link to the "other sheet" isn't working. Commented Feb 22, 2014 at 13:29

1 Answer 1

1

I've made a spreadsheet with a working example: https://docs.google.com/spreadsheet/pub?key=0Ai2d5B0yP7tLdGxPYTctVzVzdGF3NXUxeUlVS181MXc&output=html

The formula I use in column C is: =HYPERLINK(+B3;A3) In column A is the name, in column B is the url You should not forget to right click in the cells in column C and choose: show links

2
  • Hi, thanks for this. I right clicked the cell but don't see a show links option...
    – Optimesh
    Commented Feb 26, 2014 at 7:43
  • That example works because the entire contents of the cell is the link. But when I tried having some other text concatenated as well (eg C3 = ="test2: " & hyperlink(+O28, "Fred") ) the link inside the cell did not work, even before publishing the document. Commented Feb 26, 2014 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.