Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks - Move file to local drive, all links break
I have a user that created a spreadsheet. For each row entry there's a
hyperlink that he created. The hyperlink pulls up a jpg and it's pointing to a shared drive via UNC path and everyone has adequate permissions to access this drive. If you access his Excel file on the network (stored in same UNC location as jpgs) the links work. However, if you copy his Excel file to your desktop or anywhere else the links break. We get a message that says 'Cannot open the specified file.' I'm confused. Everyone has access to the network location that the links point to and the links use a UNC path. Even the user that created this file has the links break if he copies it locally. Is there something he's doing wrong? I can't figure it out. If you hold the mouse over the broken link here's what you will see verbatim on my computer: file:///C:\Documents and Settings\mcgowens\Desktop\512.002CG\512.002CG_Fron t.jpg Now, if you access the file from its network share and hold your mouse over the same link, here's what you will see verbatim on my computer: file:///\\nasden01\common\leases\512.002CG\512.000CG_Front .jpg What's happening? Why do the links work if accessing the Excel file over the network but if you copy the Excel file locally the links break? I don't get it. The links are UNC and everyone has permission to access the specfied directories. Thank you for all of your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks - Move file to local drive, all links break
Try the following format for your hyperlink: \\nasden01\common\leases\512.002CG\512.000CG_Front .jpg Basically same as you have with the "File:///" removed - this format works for our system and I connect to 50+ different servers using the above format. I basically built the document in WORD and then save as HTML - but just moving the Word document to my desktop - I can still access the various servers. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=520308 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
How can I locate links in an excel file and fix if incorrect? | Excel Discussion (Misc queries) | |||
File in C drive is always trying to access Drive A | Excel Discussion (Misc queries) | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
lower horizontal page break will not move | Excel Discussion (Misc queries) |