Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

I am trying to use relative hyperlinks between Excel

Customer Question
Hi, I am trying to...
Hi, I am trying to use relative hyperlinks between Excel spreadsheet cells and other files in the same folder, so I can use it on a flash drive without specifying the drive. I am using Windows 7 and Office 10. Even though I exclude the drive path it doesn't work saying it cannot find the file. Can you please advise me how to structure the address on the hyperlink. Thank you Colin xxxx
Submitted: 5 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 9 minutes by:
3/5/2012
Microsoft Office Technician: Cynt, Computer Support Specialist replied 5 years ago
Cynt
Cynt, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 1,021
Experience: I have a BA in Computer Information Technology and have been in the computer field for over 14 years.
Verified
cvd4311 :

There are a few ways to do this. The bottom one I have put in with pics for Excel.

Create a hyperlink to a new file:

  1. Right-click the cell or graphic you want to represent the hyperlink, and then click Hyperlink on the shortcut menu.
  2. Under Link to on the left side of the dialog box, click Create new document.
  3. Type a name for the new file in the Name of new document box.
  4. To specify a location other than the one shown under Full Path, type the new location in the Name of new document box or click Changeand then select the location you want. Click OK.
  5. Under When to edit, click an option to specify whether to open the new file for editing now or later.
  6. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in theScreenTip text box. Click OK.

Create a hyperlink to an existing file or web page:

  1. Right-click the text or graphic you want to represent the hyperlink, and then click Hyperlink on the shortcut menu.
  2. Under Link to on the left side of the dialog box, click Existing File or Web page.
  3. Do one of the following:
    • To select a file from the current folder, click Current Folder and then click the file you want to link to.
    • To select the Web page from a list of browsed pages, clickBrowsed Pages and then click the Web page you want to link to.
    • To select a file from a list of files you have recently used, clickRecent Files and then click the file you want to link to.
    • If you know the name and location of the file or Web page you want to link to, you can type that information in the Address box.
    • To select the Web page by opening your browser and searching for the page, click Browse the Web [IMAGE][SRC][/SRC][ALT][/ALT][WIDTH]100[/WIDTH][HEIGHT]100[/HEIGHT][STYLE][/STYLE][/IMAGE], open the Web page you want to link to, and then switch back to Microsoft Excel without closing your browser.
  4. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in theScreenTip text box. Click OK.

You can also go to this site and read about create and manage links to other workbooks (if that is what you need): http://office.microsoft.com/en-us/excel-help/create-and-manage-links-to-other-workbooks-HA001054812.aspx

Or you can do this for excel:

How to Insert Hyperlinks in Excel

You can place Hyperlinks in the cells on your spreadsheet. To quickly go to a different worksheet or workbook, you would simply click the link. We'll see how to do that now.

  • Click inside of cell A1 of a new spreadsheet
  • From the Excel Ribbon, click the Insert tab
  • From the Insert tab, locate the Links panel
  • Click on Hyperlink

When you click the Hyperlink item, you'll see the following dialogue box appear:

Insert Hyperlink
Full Size Image

We're going to create a link to another worksheet in this same spreadsheet. So, underLink to on the left, click on "Place in This Document".

JACUSTOMER-e8q2zvlo- :

Hi Cynt

JACUSTOMER-e8q2zvlo- :

Hi Cynt,

JACUSTOMER-e8q2zvlo- :

Please bear with me, I''m not the quickest. Let me specific and you can tell me the option to follow.

JACUSTOMER-e8q2zvlo- :

I have an Excel spreadsheet containing an index of names of groups of photographs. In the same directory I have lots of folders containing groups of photographs. I want to hyperlink each name in the spreadsheet to the correct folder of photographs, or to a specific photograph within a folder.

JACUSTOMER-e8q2zvlo- :

Using the C:\ I can make it work perfectly. But I want to put the whole on a flash drive so I can transport the index and photographs o other computers. This is where I want help. How to make it work without specifying a drive or location. I understood this to be the relative address but I can't make it work.

JACUSTOMER-e8q2zvlo- :

Sorry I have to go out now and fetch the kids from school. How can I keep in touch so you can resolve it for me as I'm sure you can. Please keep it simple.

JACUSTOMER-e8q2zvlo- :

Colin

JACUSTOMER-e8q2zvlo- :

Hi Cynt,

JACUSTOMER-e8q2zvlo- :

Are you working on my problem?

JACUSTOMER-e8q2zvlo- :

Regards,

JACUSTOMER-e8q2zvlo- :

Colin xxxxx

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Cynt, Computer Support Specialist replied 5 years ago

Sorry it took me so long to reply but we had technical difficulities. To do that you would follow these instructions:

Create a hyperlink to an existing file or web page:


  1. Right-click the text or graphic you want to represent the hyperlink, and then click Hyperlink on the shortcut menu.

  2. Under Link to on the left side of the dialog box, click Existing File or Web page.

  3. Do one of the following:

    • To select a file from the current folder, click Current Folder and then click the file you want to link to.

    • To select the Web page from a list of browsed pages, clickBrowsed Pages and then click the Web page you want to link to.

    • To select a file from a list of files you have recently used, clickRecent Files and then click the file you want to link to.

    • If you know the name and location of the file or Web page you want to link to, you can type that information in the Address box.

    • To select the Web page by opening your browser and searching for the page, click Browse the Web , open the Web page you want to link to, and then switch back to Microsoft Excel without closing your browser.


  4. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in theScreenTip text box. Click OK.

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Hi Cynt, Thank you for coming back to me. I am familiar with the normal ways to set up a hyperlink between Excel and a file in the same directory on a hard drive. If you create a hyperlink linking an Excel file and a destination file from the same directory it automatically picks up the drive letter and includes in it in the path. I'm advised there is a way, using a relative address, and provided both files are in the same location you do not have to set the path merely set the file name and it works. This means that I should be able to save both my Excel and the photo files on a Flash Drive and be able to plug it into another computer and use the Excel Index file to display the photographs from the Flash Drive regardless of what port it was plugged in. In the article I read it stated 'In a Microsoft Excel workbook unspecified paths to hyperlink destination files are by default relative to the location of the active workbook. You can set a different base address to use by default so that each time you create a hyperlink to a file in that location you'll only have to specify the the file name not the path in the Insert Hyperlink diolog box' I'm trying to get this option to work. Regards Colin xxxx
Microsoft Office Technician: Cynt, Computer Support Specialist replied 5 years ago
I am going to have to opt out of this one because I am only familiar with what I posted. I will repost so that another expert can come online to help you.
Ask Your Own Microsoft Office Question
Microsoft Office Technician: Cynt, Computer Support Specialist replied 5 years ago
I am trying to repost but it will not let me. Could you close out this quesiton and repost?
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Hi Cynt Do I have to start all over again? Colin xxxx
Microsoft Office Technician: Cynt, Computer Support Specialist replied 5 years ago
just close out this ticket and repost your question. It will not let me close it out or opt out. You should be able to opt me out by yourself. But not sure how you do it because I am not on your end of it.
Ask Your Own Microsoft Office Question
Microsoft Office Technician: Travis, Computer Enthusiast replied 5 years ago
Travis
Travis, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 93
Experience: I have 12 years of experience in the IT field.
Verified

Hello and welcome to JustAnswer~! My name is ***** ***** I would like to assist you with your question.

http://www.mediafire.com/?s3e7a5pa0po3b5s

Here is an example excel file with some pictures. This is how the folder structure is.

Excel Folder
-----Pictures Folder

-----Excel File

(Excel) folder, inside it is an excel document, and a (pictures) folder. When you open the excel file, there are 3 hyperlinks to the pictures folder and files inside them. If you right click the hyperlink and edit hyperlink it will give you a folder structure. I will look something like this: Hyperlink1 - pictures\picture1.jpg Hyperlink2 - pictures\picture2.jpg and so on. You can move this folder and all it's contents anywhere and open the excel file and the hyperlinks will work. There is not a path to any drive letters. Download the file and unzip it to your desktop and take a look.

Hope this helps!

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Hi Travis,
I tried the link to the web and got nothing but adverts and cars for prizes. I couldn't see your example. Couldn't you just email me the files.
Colin
Microsoft Office Technician: Travis, Computer Enthusiast replied 5 years ago
We don't allow contact via email unfortunately. If you click the link right in the middle of the screen it says excel.zip and right below it says download. There are ads all around it, but it is ok to download the file. Just download and unzip to your desktop.
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Hi Travis, Sorry it doesn't work. If you give me your email address I will send you images of the Worksheet, the hyperlink edit and the error to substantiate my claim. Copy your files to someone else's machine and try it. I have been on the internet and found it to be a common problem. The solution lies in changing the Base Address. I tried their solution and it works. If you're interested I will email you the hyperlink that works. Please don't waste any more time on it. Regards ***** *****
Microsoft Office Technician: Travis, Computer Enthusiast replied 5 years ago
Copied my folder to another machine and it works fine. Well as long as you got it working.
Ask Your Own Microsoft Office Question
Ask Travis Your Own Question
Travis
Travis
Travis, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 93
93 Satisfied Customers
Experience: I have 12 years of experience in the IT field.

Travis is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I have upgraded to Windows 10 and now I can not open some
I have upgraded to Windows 10 and now I can not open some files in Word. It says it can not be found on server, but shows up in file search … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,282 satisfied customers
I mistakenly ordered a second copy of Microsoft Office 365
I mistakenly ordered a second copy of Microsoft Office 365 on 1/15/18 after ordering an initial purchase on 9/2/17. … read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
How do I set if I want two columns of names? I really don't
I really don't know. I have been assigned to do a church bulletin and there are two columns of names. I'm sorry to be so stupid. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
One of my two controlers connects ok, but the other does
One of my two controlers connects ok, but the other does not. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I need to learn how to correct spell check on my computer. I
I need to learn how to correct spell check on my computer. I use Office 365 Personel … read more
Mr.Med
Mr.Med
946 satisfied customers
I HAVE TRIED OVER TEN TIMES TO ACCESS MNY MICROSOFT ACCOUNT
I HAVE TRIED OVER TEN TIMES TO ACCESS MNY MICROSOFT ACCOUNT SO i CAN BUY OFFICE WORD. i AM SO FRISTRATED BECAUSE EACH TIME i TRY IT RESULTS IN ME RETRYOING OVER AND OVER CSAN MY OLD ACCOUNT BE DISCONT… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Publisher stopped letting me save files as jpg. there is no
Publisher stopped letting me save files as jpg. there is no data in the jpg file. It will save as a pdf and gif but not jpg or png. Just started happening. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I paid tech soup 40 dollars for a new replacement for word
I paid tech soup 40 dollars for a new replacement for word and it was to be sent online. a ms partner fo a long time under***@******.*** zzzzzzzzzzzzzzi think zI saw iton my[aptop and tried to downloa… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
I am unable to get into my account, with TD. It is through
Hi I am unable to get into my account, with TD. It is through water house. It seems the computer is stuck on easy web. Every time I put on the computer TD pops up. Yet I can not get into my account. But I can do it at someone else's computer. It keeps saying I am all ready registered for easy web banking. There also telling me since it appears that you are currently registered, you should be able to log in and view. Please click easy web to access your account. I tried many times and I cannot get into my account. I would appreciate the help Thank You … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I'm a time user of Word -- Now using Word 2007. However,
I'm a long time user of Word -- Now using Word 2007. However, there is something I cannot determine how to do. That is, I need to remove the signature "block" which appears when a signature line is pl… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
How can I open and then close a document without exiting
How can I open and then close a document without exiting word so that I can quickly open the next document? … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
I just downloaded Microsoft office last week and the program
I just downloaded Microsoft office last week and the program says there is a problem and is recommending I load the program again. … read more
Cody
Cody
Computer Science
1,723 satisfied customers
I have Microsoft Office installed on my laptop. However,
I have Microsoft Office installed on my laptop. However, when I try to download a Word format attachment from an email I recieve … read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
435 satisfied customers
I have just had to reload /restore my Windows software as my
Hi, I have just had to reload /restore my Windows software as my system no longer logged onto the internet. One day to the next, it just would not show me Wifi connection details. I fixed that with th… read more
technicalcat
technicalcat
Computer Science
838 satisfied customers
I'm trying to get an IF/THEN/ELSE statement to work in a
Hi there. I'm trying to get an IF/THEN/ELSE statement to work in a mail merge. Here it is in a nutshell: … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I purchase a new Dell Laptop; order number 324841229;
I purchase a new Dell Laptop; order number###-##-#### Customer number###-##-#### as part off the purchase on 1/12/2018, was the software for Microsoft Office 365 personal. DE000000215429516 … read more
JJesus Perez Gonzale
JJesus Perez Gonzale
Bachelors of Science, Computer Engineering
37 satisfied customers
I just acquired 365 and now I cannot access any of my
I just acquired 365 and now I cannot access any of my documents. whatsup? … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
Word update downloaded automatically. I printed a few church
Word update downloaded automatically. I printed a few church bulletins before the update. I print front page and back page in landscape mode so I can fold in the middle. After the update, both front a… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x