Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 hyperlinks (2000 Sr2)

    Hi all:

    Our illustrious IT dept switched servers over the weekend. I have a client that had some hyperlinks in an Excel spreadsheet. They no longer work. The old path was ps109asr1.....; The new path should be qwars214megagis_filesS-DWGS_2004....

    What got changed was ps109asr1 to qwars214mega. The sub-paths did not get appended to the new path. Is there any way to update the new hyperlink to the correct path (short of doing each one individually). TIA

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

    Re: Excel 2000 hyperlinks (2000 Sr2)

    See the thread starting at <post#=211304>post 211304</post#>, in particular <!profile=Pieterse>Pieterse<!/profile>'s reply <post#=211636>post 211636</post#>.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 hyperlinks (2000 Sr2)

    Hans: I tried Pieterse's post but to no avail. I have attached the spreadsheet with macros. Thanks again.

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

    Re: Excel 2000 hyperlinks (2000 Sr2)

    It works OK for me in Excel 2002 SP-3. Note that there are different paths in the hyperlinks: ps109asr1... and ps109fsr1...
    You will have to run the macro for each path separately.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 hyperlinks (2000 Sr2)

    I am running Excel 2000 SP3, after upgrading from SR-1. Still no results. I was aware of the different paths, but thanks.

Posting Permissions

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