Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    hyperlinks (excel 2000)

    I have worksheets for each month of the year. On each worksheet I have several hyperlinks to web pages. They have worked just fine for 4 months. On the fifth month I get the message "unexpected error". The links are showing the correct path to the web page. Can someone please tell me what happened. Thank you. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hyperlinks (excel 2000)

    Without knowing how the hyperlinks are put together and what they refer to, it's hard to help. Can you give some more detailed information? Thanks in advance.

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlinks (excel 2000)

    I clicked on the hyperlink symbol and from there I navigated to the web page the I wanted. That inserted the hyperlink on my excel worksheet. Like I said, it has worked for 4 months. I copied it to each sucessive worksheet and up until May, it has worked fine. Now all of a sudden, unexpected error. Sorry if I'm not supplying proper info. I'm pretty green at this.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hyperlinks (excel 2000)

    If I understand correctly, you created a static hyperlink (i.e. to a fixed URL, not depending on the value of worksheet cells) on the January sheet, then copied this hyperlink to the sheets for February,etc., but now the copy on the May sheet doesn't work. What happens if you copy it anew, or create it anew?

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlinks (excel 2000)

    Hans, If I go back to the worksheets where the hyperlink worked previously, now it doesn't. It gives me the unexpected error. Same thing for March, February and January. Where once they worked, now the don't. I even tried using the hyperlink formula but that doesn't work either. I'm baffled. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlinks (excel 2000)

    Can you recreate them? Maybe there is a problem with the website or it has changed url somehow?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    New Lounger
    Join Date
    Jun 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlinks (excel 2000)

    Jan,
    I have links to various web sites and none of them work anymore. I've deleted the links and recreated them but to no avail.
    Maybe somehow I've picked up a virus or something. I'm at my wits end.
    Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hyperlinks (excel 2000)

    Have hyperlinks stopped working in Excel only, or in other applications too? If it is only in Excel or in all Office apps, but not in other apps, your Excel or Office installation may be damaged. Try Help | Detect and Repair... And of course it doesn't hurt to let your virus scanner (you *do* have one, I hope) do a complete scan of all your hard disks.

  9. #9
    New Lounger
    Join Date
    Jun 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlinks (excel 2000)

    Hans, I checked Word and the hyperlink did not work in word either. I did a repair & reinstallation of Office 2000 and now everything seems to be o.k.
    P.S. I do have a virus scanner and it detected no virus present. I must have muffed something up. Anyway, it's working great and thank you and everyone else for the input. You all are great!

Posting Permissions

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