Solved

Excel Hyperlink Issue

Posted on 2012-04-04
4
467 Views
Last Modified: 2012-04-11
I have a client that is having problems with a few excel spreadsheets that they use for order tracking. In these documents they have several hyperlinks that point to PDF documents. Both the excel files and the PDF documents reside on a 2003 Standard server. Most of the users are running Windows 7 with office 2010.  Some however are XP using Office 2007.  There are usually a few users in the file at the same time, but only one person has read/write access at a time. The other see it in read only mode.

Randomly Excel will change their hyperlinks so that instead of when clicking on the link it opens the specific pdf, it will change all of them so when you click on a link it just opens the folder in which the pdf documents are. This is an improvement over what it was doing before  of just forgetting what was there all together. I got it to at least go to the folder after I setup the hyperlink base in all the documents to start in the folder where all the pdf docs are.  

At this point however they are getting really tired of having to remap all the hyperlinks every time they change. Does anyone know of a way to get this to stop happening?
0
Comment
Question by:computerconcepts
  • 2
  • 2
4 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 37807397
The normal hyperlink inserted into a workbook can be changed or mangled by Excel when the source file is moved or the workbook containing the hyperlink is moved or emailed. To prevent this from happening use the HYPERLINK function as shown in the example below. Hyperlinks created using the HYPERLINK function will never be touched by Excel.

   =HYPERLINK("\\server\full\path\to\file.xls", "The 2006 Plan")

Kevin
0
 

Author Comment

by:computerconcepts
ID: 37807424
I will have them try using this when creating the Hyperlink. Problem with it though is these are very basic computer users if you are picking up what I am putting down. They do not like change, especially when it comes to the way they do things. Something to note however is that the files never move or are emailed. Every user has a shortcut to the exact same file on the server and the shortcut is using the UNC path and not mapped drives.
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 37807433
Excel does things to links when it feels like doing so. Using the HYPERLINK function ensures that - for whatever reason - the links will not be changed.

Kevin
0
 

Author Comment

by:computerconcepts
ID: 37807523
I am going to have them try this and see what happens. If all goes well over the next week or so I will award you the points. Thank you Kevin!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now