Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Hyperlink Issue

Posted on 2012-04-04
4
Medium Priority
?
477 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 1500 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

927 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