1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can we create hyperlinks in pivot table which takes us to the respective site ?

Discussion in 'Ask an Excel Question' started by Shraddha, Jan 20, 2018.

  1. Shraddha

    Shraddha New Member

    Messages:
    20
    I tried many options with the posts available but could not find any results.

    Thanks,
    Shraddha

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    3,458
    Shraddha
    There are 'some links' while opening that file ... (skip skip)
    You have there 'hyperlinks' ... Have You tested that those work out of Excel?
  3. Shraddha

    Shraddha New Member

    Messages:
    20
    Hi... Those are internal company web links.. yes they work at my end
  4. Shraddha

    Shraddha New Member

    Messages:
    20
    I am not able to show them in my pivot as link
  5. vletm

    vletm Excel Ninja

    Messages:
    3,458
  6. Shraddha

    Shraddha New Member

    Messages:
    20
    Basically the data with hyperlink is not seen in the pivot table.. any suggestions on how we can make the hyperlink clickable in pivot?
  7. vletm

    vletm Excel Ninja

    Messages:
    3,458
    Did You even try to do as I wrote in my previous reply?
    That was my suggestion.
  8. Shraddha

    Shraddha New Member

    Messages:
    20
    Uploaded a new file. Can you tell me how I can make those links work? The other file I shared had my company links and will not work at your end.

    I tried what you said its not helping :(

    Attached Files:

  9. vletm

    vletm Excel Ninja

    Messages:
    3,458
    Shraddha
    ... test.xlsb ...
    > yahoo works
    > gmail ... not work
    ... sample.xlsm ...
    > Only You can test it AFTER REFRESH PIVOT!

    Attached Files:

  10. Shraddha

    Shraddha New Member

    Messages:
    20
    It says type mismatch when i use in my workbook :(
  11. vletm

    vletm Excel Ninja

    Messages:
    3,458
    ... then You should check those modified formulas ...
  12. Shraddha

    Shraddha New Member

    Messages:
    20
    sorry
    i found the problem :) :) :) and now it works
  13. Shraddha

    Shraddha New Member

    Messages:
    20
    one last thing can I not use some friendly name instead of that entire huge link ?
  14. vletm

    vletm Excel Ninja

    Messages:
    3,458
    What was the challenge?
    The key now is that "https://" ...
    but ...
    it would be possible!
    Which 'friendly name' You would like to use?
  15. vletm

    vletm Excel Ninja

    Messages:
    3,458
    ... this is one possible with 'friendly name'

    Attached Files:

  16. Shraddha

    Shraddha New Member

    Messages:
    20
    The Challenge was I was trying to use some friendly name Say like I want "Click Here". Also, even if I move my cursor it opens the link. Can we restrict to only when we click it opens the link
  17. vletm

    vletm Excel Ninja

    Messages:
    3,458
    ... so You have modified that code too
    ... my version makes act then activate that cell!
  18. Shraddha

    Shraddha New Member

    Messages:
    20
    meaning should i select a different procedure ?
  19. vletm

    vletm Excel Ninja

    Messages:
    3,458
    If You would like to get comments then use my previous sent file (#15 Reply) and its code!
  20. Shraddha

    Shraddha New Member

    Messages:
    20
    dosent work .. I tried with correcting all ranges.. Can you try in the file I sent with Yahoo and gmail e.g. ? I think it dosent work with friendly name
  21. vletm

    vletm Excel Ninja

    Messages:
    3,458
    You didn't answer to my question
    ... Which 'friendly name' You would like to use?

    Send that Your 'dosent work...' here that I could compare ...

    That 'test'-file's layout is different ... not good 'friendly test'
  22. Shraddha

    Shraddha New Member

    Messages:
    20
    Uploaded here - I will need a friendly name llike "Click Here" and it will take me to the website. Also, the link should activate only when I click on it please. Currently it open if I am moving the cursor with key-pads too

    Thanks much!!

    Attached Files:

  23. vletm

    vletm Excel Ninja

    Messages:
    3,458
    Okay!
    1) That haven't my code ... challenge!
    2) I see that You didn't test my file at all ... hmm?
    3) 'Click Here' ... why need that kind of text there?
    4) 'my version' let use ex 'DealID' (if that is unique?) or
    as in my sample 'OppId'.
    Anyway NO NEED NEW only for link use column to 'Deal Details'!
    >> It's Your choice ...
  24. Shraddha

    Shraddha New Member

    Messages:
    20
    Sorry .. I sent incorrect version .. Please see attached...
  25. Shraddha

    Shraddha New Member

    Messages:
    20
    Late night effect, probably :( I am trying to get this out sooner but stuck.. Can you help with this fiile ? Also, how do i change the code so that only when it is clicked it opens the link?

    Attached Files:

Share This Page