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:
Create a hyperlink to an existing file or web page:
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.aspxOr you can do this for 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.
When you click the Hyperlink item, you'll see the following dialogue box appear:
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".
Please bear with me, I''m not the quickest. Let me specific and you can tell me the option to follow.
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.
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.
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.
Are you working on my problem?
Sorry it took me so long to reply but we had technical difficulities. To do that you would follow these instructions:
Hello and welcome to JustAnswer~! My name is XXXXX XXXXX I would like to assist you with your question.
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!