×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Hyperlink Errors
2

Hyperlink Errors

Hyperlink Errors

(OP)
Is anyone aware of a bug in Excel that disrupts a hyperlink's path when the document is saved?  In a workbook I created, the path to a hyperlink gets prepended with "../../../.." replacing the "\\NetPath01" when I save the workbook, no matter how many times I correct it and no matter how I go about editing or creating the hyperlink.  Now, the weird part about it, is that this will only happen if the file is being saved on a network drive as opposed to a local drive.  Any knowledge or fix you may have would be GREATLY appreciated.

RE: Hyperlink Errors

2
furley
Hyperlinks are used by browsers in two different ways, either absolute (as in http://www.eng-tips.com) or relative in which case the address takes a BASE (such as the current page) and refers to others with a path which includes .. and / to designate back and down.
Go to file|properties|summary and set a base for the hyperlinks.  Perhaps it could be the root directory of your network.
It works for me, but then I hadn't noticed a problem in the first place

David

RE: Hyperlink Errors

(OP)
YEP!!!  That worked!!  Thanks!!  That is just one of those things that I have never come across.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources