Excel 2010 Hyperlinks changed from Network file path to a Local Path??

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel 2010 Hyperlinks changed from Network file path to a Local Path??

  1. #1
    New Member
    Join Date
    Jun 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Excel 2010 Hyperlinks changed from Network file path to a Local Path??

     
    Hello, so I had to manually insert hundreds and hundreds of hyperlinks that link to PDF files on a network server. When I finally finished linking all on my list and going back through, I discovered that when I clicked on many of the hyperlinks, it popped up a message saying "Cannot open the specified file." When I looked at the file path, many of them changed to C:\Users\[my login name]\AppData\[and then the rest of the file path was correct]?? How do I get it to change all of my hyperlinks to the same hyperlink base address (I have tried that in File-Properties-Summary tab but doesn't work??) I have also tried some module samples I found on the internet but nothing I try will work?? Please help.......

  2. #2
    New Member
    Join Date
    Jun 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel 2010 Hyperlinks changed from Network file path to a Local Path??

      
    I think I'm having the same kind of issue - changing hyperlink base doesn't work
    I've two folders with files in them
    z:\\01 Quality Assurance\QA docs\ - contains my documents
    z:\\01 Quality Assurance\QA records - the spreadsheet with a list of docs I want to hyperlink to
    I followed the directions for Excel 2010 to change the hyperlink base: file, properties, advanced properties, summary and in the "hyperlink base" box entered z:\\01 Quality Assurance\QA Docs\
    When I do Insert & click Hyperlink, the dialog box opens to QA Records not QA Docs. Why?

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com