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
Ok where are the download links?
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.
Kathleen, both the above links are for the Word file. I need the Excel file so I can set up the link in
Ok here are the two files zipped together.
(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
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
Will review your last comments and get back to you
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
Ok will look at it later in the day
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.