Solved

Excel Hyperlink Issue

Posted on 2012-04-04
4
468 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 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