1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2002 - hyperlinks open wrong file

Discussion in 'Business Applications' started by 76patriot, Apr 6, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    I have a spreadsheet that has hyperlinks to pics in a different folder. I click on the link and the wrong pic opens....all the links open the same wrong pic. It worked correctly before and the actual text in the link is correct. Anyone know what is going on and what is the fix?

    System - XP Pro
     
    76patriot, Apr 6, 2010
    #1
  3. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    Right click the link and choose "EDIT HYPERLINK"

    Make sure the link is pointing to the correct file.

    Rollin
     
    Rollin_Again, Apr 6, 2010
    #2
  4. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    I already stated that the text in the link is correct....i.e. link is pointing to correct file. I don't get it.
     
    76patriot, Apr 7, 2010
    #3
  5. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    21,000
    First Name:
    Jay
    I've seen this problem before in Excel/Word 2003 ... Don't really remember what I did to make it go away.
    Just guessing .. Have you cleaned out your temp internet files and other saved Junk ??
    ... Maybe a good cleaning with CCleaner ???
     
    Noyb, Apr 7, 2010
    #4
  6. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    Cleaned temp files and still have problem. Prefer not to "guess" and do things that "might" fix. It has been my experience that sometimes it causes other problems when you experiment. There is a cause....just need help finding the exact cause. Thanks for your help anyway.
     
    76patriot, Apr 7, 2010
    #5
  7. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    21,000
    First Name:
    Jay
    Is it fixed if you remove and replace the link ??
     
    Noyb, Apr 7, 2010
    #6
  8. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    I removed the link and created a new link and it still goes to the wrong pic. As I said before....the link has the correct text and location.
     
    76patriot, Apr 7, 2010
    #7
  9. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    21,000
    First Name:
    Jay
    I know .. I've stumbled across this before ... Just one link ???
    Try this .. create a new link somewhere else ... see if it works OK .. then Move it to where the bad one is... (replace)

    Maybe replace it from a new Excel file ??? .. Copy > Paste

    You might also try this ..
    Shut the computer down >> remove the power from the wall >> Press n Hold the Power button for about 30 seconds >>
    Reconnect the power and turn the computer back on.
     
    Noyb, Apr 7, 2010
    #8
  10. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    Tried reset restart...no help. Tried new link to new cell...still links to same wrong pic.
     
    76patriot, Apr 7, 2010
    #9
  11. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    21,000
    First Name:
    Jay
    I wish I could remember what I did when I saw this problem .. I think I was in Word making a web page ??

    What happens if you make a new Excel with a new link ??
     
    Noyb, Apr 7, 2010
    #10
  12. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    New excel link worked....saved, closed, opened....link did not work....did not open pic...just blank irfanview for pic.
     
    76patriot, Apr 7, 2010
    #11
  13. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    21,000
    First Name:
    Jay
    The only thing I can think of now .... Is to remove and reinstall Office ??
     
    Noyb, Apr 7, 2010
    #12
  14. 76patriot

    76patriot Thread Starter

    Joined:
    Apr 6, 2010
    Messages:
    7
    I think I will stop using the feature first. Maybe a repair is in order.
     
    76patriot, Apr 7, 2010
    #13

  15. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Excel 2002 hyperlinks
  1. ybor10000

    Excel file for storing macros closes when trying to view mac

    ybor10000, Mar 25, 2020 at 11:49 AM, in forum: Business Applications
    Replies:
    1
    Views:
    156
    Cookiegal
    Mar 26, 2020 at 9:07 AM
  2. crashdown

    Solved Excel seperate data into a Matrix

    crashdown, Mar 10, 2020, in forum: Business Applications
    Replies:
    1
    Views:
    491
    crashdown
    Mar 11, 2020
  3. ubamous3

    Excel (2010) mouse auto lose focus on current editing cells

    ubamous3, Feb 22, 2020, in forum: Business Applications
    Replies:
    4
    Views:
    867
    DaveA
    Mar 2, 2020
  4. sjtrupp

    excel truncating last digit after period

    sjtrupp, Feb 19, 2020, in forum: Business Applications
    Replies:
    1
    Views:
    793
    cwwozniak
    Feb 19, 2020
  5. saj1011

    How to pull in data from Sheet A to Sheet B in Excel?

    saj1011, Feb 19, 2020, in forum: Business Applications
    Replies:
    2
    Views:
    847
    Professionalgirl
    Mar 1, 2020
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/915126

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice