Excel Hyperlink Issue

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?
computerconceptsAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
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
 
computerconceptsAuthor Commented:
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
 
zorvek (Kevin Jones)ConsultantCommented:
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
 
computerconceptsAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.