Spreadsheet: 180894d1347860128-excel-2007-show-the-actual-url-in-column-of-hyperlinked-cells-hyperlink-test
Sheet: sheet1

NASA CDM | HC Name | Global / Regional | Owner | NorthAm CM | EMEA CM | ASIA CM1 | ASIA CM2 | ASIA CM3 | LATAM CM | [NAME] | Account Plan Name | # of Account Plan Goals | # of Account Plan Details | Account Plan Dashboard LINK | Sum of # of Account Plans | HYPERLINK TO ACTIVATE
(blank) | ABC | GLOBAL | Doe, [NAME] | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | Account Plan - ABC CORE | Account Plan - ABC CO | 3 | 2 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=AMHA-1MOTOY&P4=eq&P5=Account.%22Parent+Account+External+Id%22&P6=AMHA-1MOTOY&P7=eq&P8=CustomObject5.ROW_ID&P9=AMHA-1MQY4C | 1 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=AMHA-1MOTOY&P4=eq&P5=Account.%22Parent+Account+External+Id%22&P6=AMHA-1MOTOY&P7=eq&P8=CustomObject5.ROW_ID&P9=AMHA-1MQY4C
 | DEF | GLOBAL | Doe, [NAME] | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | Account Plan - DEF CORE | Account Plan - DEF CO | 3 | 2 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=ACMA-6533EC&P4=eq&P5=Account.%22Parent+Account+External+Id%22&P6=ACMA-6533EC&P7=eq&P8=CustomObject5.ROW_ID&P9=AMHA-1MR22G | 1 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=ACMA-6533EC&P4=eq&P5=Account.%22Parent+Account+External+Id%22&P6=ACMA-6533EC&P7=eq&P8=CustomObject5.ROW_ID&P9=AMHA-1MR22G
 | GHI | GLOBAL | Doe, [NAME] | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | Account Plan - GHI CORE | Account Plan - GHI CO | 3 | 2 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=1-4W1PYM&P4=eq&P5=Account.%22Parent+Account+External+Id%22&P6=1-4W1PYM&P7=eq&P8=CustomObject5.ROW_ID&P9=AMHA-1MROZA | 1 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=1-4W1PYM&P4=eq&P5=Account.%22Parent+Account+External+Id%22&P6=1-4W1PYM&P7=eq&P8=CustomObject5.ROW_ID&P9=AMHA-1MROZA
 | XYZ | GLOBAL | Doe, [NAME] | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | Account Plan - XYZ CORE | Account Plan - XYZ CO | 3 | 2 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=1-4QL08Y&P4=eq&P5=Account.%22 | 1 | https://secure-vmsomxmha.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCompany_11136_Shared_Folder%2F_portal%2Fzzz%20Account%20Plan&Action=Navigate&P0=3&P1=eq&P2=Account.%22Account+ID%22&P3=1-4QL08Y&P4=eq&P5=Account.%22
(blank) Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com