Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac

I would like to link a word document in an excel spreadsheet

Customer Question
on the Mac. I...
I would like to link a word document in an excel spreadsheet on the Mac. I don't want the text of the document to appear in the spreadsheet (which I can do by choosing Insert/Object.) I want the pathname of the document to appear in the spreadsheet. Then I want to be able to click on the pathname and go to the word document. If I do the following:

Choose Insert from menu bar
Choose Hyperlink
Choose Document
Choose File which prompts me to go to the file name.
Click on the file name

I can get the filename to appear, but when I then click on the pathname in the excel spreadsheet it does not take me to the document, rather it gives me an error message, "cannot open specified file."

Any ideas?

Thanks
KB
Submitted: 6 years ago.Category: Mac
Show More
Show Less
Ask Your Own Mac Question
Answered in 21 hours by:
11/5/2011
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified
If you can send me both the Word file and the Excel file I will try to set up the link for you
Ask Your Own Mac Question
Customer reply replied 6 years ago
Hi John, I can't find the ACCEPT button. The word ACCEPT is not a live link.

XXXXX XXXXX
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Hi Kathleen,

 

I have not posted an answer to your question yet, so you will not see the accept button until I have posted the answer. Thanks for asking though

 

In fact am waiting for you to send me the files

 

 

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
Hi John,

Sorry it took so long. I replied in a regular email instead of in this box. Just learning how to work with Justaswer.

The first file is the excel file.

The first worksheet in the workbook is called overview. You will see a column on down aways that says Word Doc. or something like that.

The second and third files are a word documents that contain interviews with the teachers referenced in the overview. You can see from the word document column that I got the pathname to download, but couldn't get the word document to open once I had the pathname in the excel doc.

Please link up the Tschudy interview with one of the Tschudy rows



and the Whipp interview with one of the Whipp rows.

Thanks so much for working on this.

Best,

XXXXX XXXXX
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Ok where are the download links?

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
When I sent you a regular email, I attached the files to the email. But when I click on the paper clip on the reply box, it prompts me to put in a graphic; it does not send me to my finder so I can attach the files. How do I get the files to you?

kathleen
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Email is not permitted on this site. Please go to http://www.2shared.com/

and upload the file (no need to signup) then copy the download link that you will be given and paste it here in your reply.

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
http://www.2shared.com/file/rh1CEMqN/Interview_Questions_Answer_She.html

above is the download link

http://www.2shared.com/fadmin/23770312/bc123048/Interview_Questions_Answer_She.docx.html

above is the administration link.

John,

hope this works. I'm off to the theater and will have no more time to reply until I get home about 5:00 PM PST

Good luck. Sorry I didn't get the files to you until now. It is all new to me about how to do this.

Best,

Kathleen
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Kathleen, both the above links are for the Word file. I need the Excel file so I can set up the link in

 



 

Ask Your Own Mac Question
Customer reply replied 6 years ago
http://www.2shared.com/file/Y_hY461T/Design_Thinking_Curriculum_spr.html

Hi John,

Well you certainly have the patience of a saint. I did upload the excel file. Not sure why it didn't come though. Anyway above is the link just for the excel file. Hope this works.
Best,

Kathleen
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Thanks

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Ok here are the two files zipped together.

 

http://www.2shared.com/file/LdyXZULS/Both_Files.html

 

(make sure to click the blue DOWNLOAD button at the bottom of the download page)

 

After downloading the zipped file, extract the files and save them both in the same folder then open the excel file. The hyperlink is in cell E1

 

If you want to change the location of the Word file you will need to reset the hyperlink. To display the new path in the cell CTRL + Click on the cell, and select Edit Hyperlink. The top field shows the display name, the bottom field shows the path. Copy the path to the display name.

 

Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

 

 

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified
John D and 87 other Mac Specialists are ready to help you
Ask your own question now
Customer reply replied 6 years ago
Hi John,

I Downloaded both files that were zipped together. the Bonia Whipp word file is in the excel spread sheet and it works as a live link. Now I need to know how you did that. I have to link several interviews to the overview spreadsheet. Please tell me the steps you took to get the file into excel and to make a live link. As you know, I managed to get the path name into excel, but could not make it a live link. I just tried it again and could not get a live link - just a pathname. Here is what I did:
in excel, i chose Insert/Hyperlink/ when the pop up appeard I click highlighted Document and then Search. i highlighted the file name and then I clicked open. When I clicked open, the pathname of the file I clicked on appeared at the top of the Hyperlink pop up in the box labeled "link to." Underneath is a box labeled "Display". I created a shorter name for the file and pressed OK. I got the name of the linked file in the spreadsheet, but the link isn't live. So please tell me now you made yours live and I will GLADLY press ACCEPT and pay you. And I will ask for you again next time if there is a next time. THanks so much, KB
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

 

I am not sure how much longer this question is going to extend but you could certainly have clicked Accept by now as so far all may time has been gratis

 

Anyway not a problem. Will opt out. Good luck

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
John, I agree that you have spent a long time on this and I am happy to pay your more. But if I cannot replicate what you did, how can it do it myself? If you can just tell me how to do what you did, I will gladly pay you standard $58. But just having it done for me, doesn't help me do it myself. I am not trying to string you along. Kathleen
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Thanks Kathleen

 

Will review your last comments and get back to you

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
Thank you. I accepted your work to date and gave you a positive review. If you can tell me how to replicate it, I will pay you the same amount again (if I can figure out how.) otherwise, I will try to tip you.

Thanks so much,

Kathleen
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Kathleen,

 

I read your last comments and I am finding that in my post last night I did include the instructions for applying the link yourself. Here it is again:

 

"...If you want to change the location of the Word file you will need to reset the hyperlink. To display the new path in the cell CTRL + Click on the cell, and select Edit Hyperlink. The top field shows the display name, the bottom field shows the path. Copy the path to the display name..."

 

Now if there is any part in the above procedure that is not clear or if when you try this you get stuck somehere just let me know which part you need help with so I can give you more detail

 

Let me know

 

 

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
Hi John,

Below are the parts i'm unclear on. Before you read that, I think there is a version problem. Get this: When I open your version from my downloads by clicking on it, I can open the link. When I Save As that file into a new location and then reopen it, I cannot get the link to work. It sounds unbelievable, but that is what happens. I've tried to three times.

I am using Word 2008 version 12.3.1 and excel 2008. version 12.3.1. Maybe the Hyperlink function can only be made in a more recent version, but can be opened in my version.

"If you want to change the location fo the Word file." Now does this mean if I want to link a different word file to a different cell? That is what I need to do. I have several interviews and each needs to be linked to the summary of the lesson plan discussed by the teacher who as interviewed.

So let's assume that I am in a new cell want to link a new word file (not the one you linked.) Next question:

So I go to the cell in excel to which I want to link a word file and press CTRL and then click the mouse. When I do that the cell is outlined in light blue. Your next instructions are "select Edit Hyperlink. If I go to the Edit menu, there is not Hyperlink option. I have two options 1. Go to the Insert menu and click on Hyperlink or do a right mouse click and choose Hyperlink. Either way I get the Hyperlink menu. Your next instruction tells me to "Copy the path to the display name." I now have two choices (and I hope a third, which is the one I don't understand how to do). 1. Go to the second part of the Hyperlink menu and Select a document through my finder. When I click on that word document, the name appears in the Link to and in my excel file, but the link doesn't work when I go to th excel file. Or, I can do what you said and go the the finder, independently of that menu, copy the file name into the link to and display boxed. Either way I cannot get my link to work. I have closed and reopened the file and that does not help.
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Ok will look at it later in the day

 

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Hi Kathleen,

 

What you have done is not quite what you are supposed to do. Ok let me simplify the procedure and present it in an outline format

 

1- Close all Excel and Word files and all Office application

2- Open the Excel file that you would like to place the hyperlink in

3- Select the cell in question

4- Press CMD-K keys to insert a hyperlink

 

The following steps are all in the hyperlink dialog box:

 

5- Select the Document button (or click the 'Existing File or Webpage' button depending on your version of Excel)

6- Navigate to the location where your Word document is stored, and select it

7- Copy the file path from the address field and paste it in the "Text to Display" field

8- Click OK

 

That should do it for that file

 

Hope this helps.

 

Thanks

 

Ask Your Own Mac Question
Ask John D Your Own Question
John D
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Worked on Macs and PC's for 20+ years.

John D 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:

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

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

< Previous | Next >

Meet the Experts:

Mike

Mike

Mac Medic

8,552 satisfied customers

Over 20 years IT experience with Apple computers in publishing, marketing and design.

Daniel

Daniel

Mac Genius

4,711 satisfied customers

Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.

Vinod Menon

Vinod Menon

Support Specialist

2,370 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,979 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,468 satisfied customers

BSc H.Dip Apple Certified Professional

Claws224

Claws224

IEEE Datacommunication Engineer

965 satisfied customers

IEEE, Microsoft

Mac Tech

Mac Tech

Apple Specialist

888 satisfied customers

7 + Years Supporting Apple Products

< Previous | Next >

Related Mac Questions
I cannot open Excel on my iMac. Os El Capitan X 10.11-6.
I WAS AWAY ALL LAST WEEK. TURNED OFF MY COMPUTER AND WHEN I RETURNED EXCEL NO LONGER RESPONDED… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,207 satisfied customers
Im on my moms computer trying to help her. Her excel program
Im on my moms computer trying to help her. Her excel program is not working and will not open at all. I have the original Office.mac dvd but dont know how to reinstall excel without losing whatever da… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
My microsoft excel froze with the SWOD. Mac os sierra. A
my microsoft excel froze with the SWOD JA: What's the model and Operating System (OS) of your device? Customer: mac os sierra JA: When did you purchase your Apple device? What troubleshooting have you… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I can't open excel on my Mac. This is a MacBook Pro Retina
This is a MacBook Pro Retina 2012 and operating macOS Sierra … read more
Jason Jones
Jason Jones
AAS Information Technology
6,316 satisfied customers
I can't dictate into excel with dragon Pre 15. Dell. Few
I can't dictate into excel with dragon Pre 15 JA: What's the make and model of your computer? And what version of Excel are you using? Customer: dell JA: Have you installed any updates recently? Custo… read more
Justin Johnson
Justin Johnson
Training and Development Contractor
484 satisfied customers
I have been using Excel for years now. In the last few
I have been using Excel for years now. In the last few weeks, whenever I input information and hit the "enter" key, the line I entered information on turns black. The info is there but not visible unl… read more
Kris R
Kris R
IT Manager
Computing
2,256 satisfied customers
Hanging with Word and Excel - just did updates. No idea. It
It is a Mac mini, i7 with 16 mb ram purchased in 2013, it should be running the latest Mac OS … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I tried to download Adobe Export PDf to save in excel
I tried to download Adobe Export PDf to save in excel format. I signed up for the 1.99/mo though it didn't let me download and as I try to do it again it says I have already done it and can't do it ag… read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
426 satisfied customers
When using excel it keeps reexing and I get the littl
when using excel it keeps reexing and I get the littl spinnng wheel what can i do to combat this … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,207 satisfied customers
Excel for Mac. The tabs at the bottom of the page have
Excel for Mac. The tabs at the bottom of the page have disappeared. Tried changing preferences as suggested and no change.Thanks.… read more
Jon
Jon
Bachelors Degree
377 satisfied customers
I need the excel text converter for mail merge on an old
I need the excel text converter for mail merge on an old macbook pro … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
775 satisfied customers
I am getting this error in my Mac word and excel Microsoft
I am getting this error in my Mac word and excel Microsoft Error Reporting log version: 2.0Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2017-08-23 02:58:26 +0000 Application Name: Microsoft W… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I cannot see tabs in an excel document, its on cloud, 1 full
i cannot see tabs in an excel document JA: When did you last update Excel? Customer: its on cloud JA: What have you tried so far with your Excel? Customer: 1 full screen 2. tiled in window view JA: An… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
628 satisfied customers
I have the 2004 version of Excel & Word for MAC. If I
I have the 2004 version of Excel & Word for MAC. If I upgrade to 2016, will my spreadsheets work seamlessly? Thank you. … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
My excel is freaking out and opening many random files,
my excel is freaking out and opening many random files … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have an iPad that is about 5 years old in excellent
I have an iPad that is about 5 years old in excellent condition. It's a 16gb. The model # is MD328LL/A. If I sell it on eBay, what is the going rate usually these sell?… read more
Justin Johnson
Justin Johnson
Training and Development Contractor
484 satisfied customers
I have a Mac desktop with microsoft word and excel
I have a Mac desktop with microsoft word and excel applications. The document I wish to open in excel keeps giving me a not responding message. … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have excel 97 on my laptop. I have some excel 97
I have excel 97 on my laptop. I have some excel 97 worksheets on a thumb drive from another PC. The laptop 97 won't open these. Why?… read more
Josh
Josh
It Support Specialist
Associate Degree
5,125 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