View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PhilosophersSage PhilosophersSage is offline
external usenet poster
 
Posts: 55
Default All Hyperlinks have changed the path

If useing 2007 goto the Data tab, then under Connections select "edit links"

Hope this helps

"bevchapman" wrote:

All my hyperlinks have changed their path - switched the drive and point to a
directory that doesn't even exist. Not sure how this could happen as I
cannot find a way to change them all back without doing it individually. I
have Approx. 3500 links!

Any ideas on how to correct these links all at once would be greatly
appreciated.