+ Reply to Thread
Results 1 to 2 of 2

excel hyperlinks open 2 duplicate chrome tabs

  1. #1
    Registered User
    Join Date
    01-03-2015
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    55

    excel hyperlinks open 2 duplicate chrome tabs

    Hi peeps. I'm stumped.
    Whenever I click on hyperlinks from my excel overview sheet to our website, chrome opens 2 duplicate tabs
    The 2 types of hyperlink formulae are here:

    =IF('invoice analyser'!DX155=0,"",HYPERLINK("https://specialist.treebuddy.co.uk/x/account/"&'invoice analyser'!DX155&"/","A"&'invoice analyser'!DX155))

    =HYPERLINK("https://specialist.treebuddy.co.uk/x/invoice/"&'invoice analyser'!B155&"/",IF('invoice analyser'!B155=0,"",'invoice analyser'!B155))

    or these simplified

    =IF(A1=0,"",HYPERLINK("https://specialist.treebuddy.co.uk/x/account/"&A2&"/","Link"))

    =HYPERLINK("https://specialist.treebuddy.co.uk/x/invoice/"&A3&"/","Link")

    The following hyperlink to open google maps works fine (ie only opens 1 tab)

    =HYPERLINK("https://www.google.com/maps/dir/Main+Drive+Wembley/"&A5,"Link")

    To my mind, this is in the same format as the ones above that open 2 tabs, suggesting it's something in chrome or our website rather than in excel..?
    Any ideas?

    Cheers,
    Mike

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: excel hyperlinks open 2 duplicate chrome tabs

    What happens if you switch default browsers to IE?

+ 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. drag columns much like tabs in firefox/chrome?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2015, 05:17 AM
  2. Put URLs into Excel from open instances of Chrome
    By Skybeau in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 06:12 AM
  3. Need to Open Web Query in Chrome
    By loveexcel2014 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2014, 12:27 PM
  4. Replies: 0
    Last Post: 01-10-2014, 06:36 PM
  5. How do I open with Chrome and not Internet Explorer?
    By walterscj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 11:13 AM
  6. need a Macro to open chrome from excel when I click on Keyword
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-17-2013, 04:40 AM
  7. [SOLVED] Macro for opening hyperlinks present in excel sheet in Mozilla or Chrome.
    By pari9485 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2013, 06:21 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