Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hyperlink base address
in a worksheet, how do i set the base address for hyperlinks? i hyperlink
hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. |
#2
|
|||
|
|||
hyperlink base address
Have you tried this?:
In the Workbook with the hyperlinks: FilePropertiesSummary ’Hyperlink Base: Enter whatever base path you need. All workbook hyperlinks will be saved relative to that setting. Does that help? ’’’’’’’’’’ Regards, Ron "RWS" wrote: in a worksheet, how do i set the base address for hyperlinks? i hyperlink hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. |
#3
|
|||
|
|||
hyperlink base address
hi ron
yes i have tried that, no change. "Ron Coderre" wrote: Have you tried this?: In the Workbook with the hyperlinks: FilePropertiesSummary ’Hyperlink Base: Enter whatever base path you need. All workbook hyperlinks will be saved relative to that setting. Does that help? ’’’’’’’’’’ Regards, Ron "RWS" wrote: in a worksheet, how do i set the base address for hyperlinks? i hyperlink hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. |
#4
|
|||
|
|||
hyperlink base address
Maybe if you change the hyperlink base to C:\, then the link will keep its
correct name--instead of excel trying to shorten it. ps. I like to use the =hyperlink() worksheet function. I've never seen excel mess with those. RWS wrote: in a worksheet, how do i set the base address for hyperlinks? i hyperlink hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. -- Dave Peterson |
#5
|
|||
|
|||
hyperlink base address
Thanks Dave, what is the =hyperlink() worksheet function? and how do i use it?
"Dave Peterson" wrote: Maybe if you change the hyperlink base to C:\, then the link will keep its correct name--instead of excel trying to shorten it. ps. I like to use the =hyperlink() worksheet function. I've never seen excel mess with those. RWS wrote: in a worksheet, how do i set the base address for hyperlinks? i hyperlink hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. -- Dave Peterson |
#6
|
|||
|
|||
hyperlink base address
Looking in Excel's help would describe it greater detail, but it's a worksheet
function: =HYPERLINK(link_location,friendly_name) Kind of like: =HYPERLINK("http://www.microsoft.com","Click here to go to MS's site") or =HYPERLINK("file:////c:/my documents/excel/book1.xls","Click to open") If the files all exist in one folder, I can put that folder name in A1 and the filenames in (Say) A2:A99. Then I can use this kind of thing in b2:B99: =hyperlink("file:////" & $a$1 & a2, "Click to open") or even =hyperlink("file:////" & $a$1 & a2 & ".jpg", "Click to open") depending on what I put in A2:A99. Then if the folder changes name, I just fix A1 and all my links are adjusted. RWS wrote: Thanks Dave, what is the =hyperlink() worksheet function? and how do i use it? "Dave Peterson" wrote: Maybe if you change the hyperlink base to C:\, then the link will keep its correct name--instead of excel trying to shorten it. ps. I like to use the =hyperlink() worksheet function. I've never seen excel mess with those. RWS wrote: in a worksheet, how do i set the base address for hyperlinks? i hyperlink hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
hyperlink base address
Thanks Dave, i'll give it a try.
"Dave Peterson" wrote: Looking in Excel's help would describe it greater detail, but it's a worksheet function: =HYPERLINK(link_location,friendly_name) Kind of like: =HYPERLINK("http://www.microsoft.com","Click here to go to MS's site") or =HYPERLINK("file:////c:/my documents/excel/book1.xls","Click to open") If the files all exist in one folder, I can put that folder name in A1 and the filenames in (Say) A2:A99. Then I can use this kind of thing in b2:B99: =hyperlink("file:////" & $a$1 & a2, "Click to open") or even =hyperlink("file:////" & $a$1 & a2 & ".jpg", "Click to open") depending on what I put in A2:A99. Then if the folder changes name, I just fix A1 and all my links are adjusted. RWS wrote: Thanks Dave, what is the =hyperlink() worksheet function? and how do i use it? "Dave Peterson" wrote: Maybe if you change the hyperlink base to C:\, then the link will keep its correct name--instead of excel trying to shorten it. ps. I like to use the =hyperlink() worksheet function. I've never seen excel mess with those. RWS wrote: in a worksheet, how do i set the base address for hyperlinks? i hyperlink hundreds of product photos to item numbers in my inventory worksheet. when inserting hyperlinks i have to move up the directory numerous levels to get to my vendors folder where i store the item photos. i have tried the process microsoft recommends but it doesn't work. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Troubleshoot resetting hyperlink base to a network drive | Excel Worksheet Functions | |||
Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
email address hyperlink | Excel Worksheet Functions | |||
Can I create a dynamic email address in Excels hyperlink? | Excel Worksheet Functions |