View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shawn McGowen
 
Posts: n/a
Default 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!