+ Reply to Thread
Results 1 to 2 of 2

Hyperlinks in Pivot Table

  1. #1
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Hyperlinks in Pivot Table

    Hi,

    I have a formula in a cell which creates a hyperlink to google maps, and displays the "SUBURB STATE" as the actual cell text.

    This is the formula;
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you click the link it takes you to google maps and displays the suburb with a border and shading to indicate the shape of the suburb.

    This works fine.

    However I would like the hyperlinks to google maps to be available in a pivot table, so if I am investigating where a trend or outlier is located I can click the location and bring it up in google maps.

    Any ideas?

    Thanks

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Hyperlinks in Pivot Table

    Hi,

    You'd need to use code for that. Simplest method is a Worksheet_SelectionChange event that tests if the selected cell is in whichever pivot field is relevant and then uses the Workbook.FollowHyperlink method to open the link.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Internal Hyperlinks in pivot table (Excel 2010)
    By helpmij in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 12-22-2017, 05:08 AM
  2. [SOLVED] Hyperlinks in Pivot table.
    By Masken in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 03-21-2014, 02:22 PM
  3. Hyperlinks in Pivot table.
    By Masken in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2013, 09:40 AM
  4. web hyperlinks in pivot table
    By afgi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2010, 01:02 PM
  5. how to create dynamic hyperlinks to a cell of a pivot table
    By ramonsojos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2010, 05:31 PM
  6. Pivot table result with hyperlinks
    By KouDy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2007, 04:00 AM
  7. pivot table and hyperlinks
    By Gailc in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 03:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1