Results 1 to 2 of 2

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

This is a discussion on Excel 2010 Hyperlinks changed from Network file path to a Local Path?? within the Excel Questions forums, part of the Question Forums category; Hello, so I had to manually insert hundreds and hundreds of hyperlinks that link to PDF files on a network ...

  1. #1
    New Member
    Join Date
    Jun 2013
    Posts
    1

    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

    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?

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