Solved

Excel Hyperlink Issue

Posted on 2012-04-04
4
473 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

624 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