+ Reply to Thread
Results 1 to 15 of 15

Problem creating a hyperlink to a file

  1. 12-12-2018, 01:45 PM #1
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Problem creating a hyperlink to a file

    Hello,

    Previously I have created hyperlinks to files in a local directory. When I activate them, they locate and open the file as expected. Now I am trying to create additional hyperlinks to files in the same directory but are somewhat "buried". The paths are 4 or 5 sub-folders deep. Excel can't even seem to find the file, much less open it. The path is long but still well under 255 characters (a number I have seen in a few posts as being a limit). Is there a limit to the number of sub-folders Excel is capable of navigating through? Or is it more likely an issue with how the the directory is set up? Any insight would be greatly appreciated.

    Thanks
    Last edited by MacPadana; 12-12-2018 at 01:47 PM. Reason: Typo
    Reply With QuoteRegister To Reply
  2. 12-12-2018, 02:10 PM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Problem creating a hyperlink to a file

    .
    Most likely a typographical error ...
    Reply With QuoteRegister To Reply
  3. 12-12-2018, 02:19 PM #3
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Problem creating a hyperlink to a file

    Post the formula that you are trying to use, or better still, attach a sample Excel workbook (not a picture of one).

    Pete
    Reply With QuoteRegister To Reply
  4. 12-12-2018, 03:21 PM #4
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Problem creating a hyperlink to a file

    Sample file is attached. At least I think it is. Hyperlink is in cell N27
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-12-2018, 04:18 PM #5
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Problem creating a hyperlink to a file

    Looks to me the issue is you are trying to open a file from a .zip location which i don't believe is possible. Correct me if i am wrong though.
    Reply With QuoteRegister To Reply
  6. 12-12-2018, 05:35 PM #6
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Problem creating a hyperlink to a file

    You are correct that it is a .zip location. I wasn't aware that could be a problem. I can move the file to a non-zip folder but it will still be several levels down the chain. I'll try that and report back.

    Thanks for the help!
    Reply With QuoteRegister To Reply
  7. 12-12-2018, 05:38 PM #7
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Problem creating a hyperlink to a file

    The hyperlink should work even if it is in many subfolders; Just as long as there are no .zip locations. I believe this has something to do with .zip being treated as a file rather than as a folder. (At least that is what i found through my research.)
    Reply With QuoteRegister To Reply
  8. 12-13-2018, 03:02 PM #8
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Problem creating a hyperlink to a file

    Updated file is attached. No Zip folders in this path. Still won't get past the first folder in the directory. Any other thoughts on what could be wrong?
    Attached Files Attached Files
    Last edited by MacPadana; 12-13-2018 at 03:09 PM.
    Reply With QuoteRegister To Reply
  9. 12-13-2018, 03:34 PM #9
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Problem creating a hyperlink to a file

    i am running out of ideas for this.
    Do you receive an error message when trying to open the link?

    more research has pointed to changing update links on saves option. i will include the link.
    http://www.repairmsexcel.com/blog/tr...ks-not-working

    [I am not sponsoring this website or the use of the downloaded tool represented on the above link. Only pasted because it has an example of how to potentially fix hyperlinks and i did not want to copy and paste all the information.]
    Reply With QuoteRegister To Reply
  10. 12-13-2018, 04:27 PM #10
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Problem creating a hyperlink to a file

    I really appreciate your efforts. I don't get an error message. Just a windows explorer window. Tried pasting a snapshot of it into this post but can't seem to figure out how.
    Reply With QuoteRegister To Reply
  11. 12-13-2018, 04:33 PM #11
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Problem creating a hyperlink to a file

    Select Go Advanced on this forum.
    Then select Manage Attachments.
    Select Choose Attachment
    Select your screenshot.
    Select Upload.

    this should upload the screenshot.
    Or you could just type out what the windows explorer dialog box states.
    Reply With QuoteRegister To Reply
  12. 12-17-2018, 03:05 PM #12
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Problem creating a hyperlink to a file

    OK,

    I pasted the window that pops up into the body of the Excel File.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 12-17-2018, 03:45 PM #13
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Problem creating a hyperlink to a file

    Its the "#" in the folder's name that is messing the link up.
    here's the microsoft link with explanation...

    https://support.microsoft.com/en-us/...yperlink-in-an
    Last edited by dosydos; 12-17-2018 at 03:48 PM.
    Reply With QuoteRegister To Reply
  14. 12-18-2018, 08:54 AM #14
    MacPadana
    MacPadana is offline
    Registered User
    Join Date
    11-10-2010
    Location
    Sheboygan, WI
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Problem creating a hyperlink to a file

    WOW!!!

    Thank you so much. I can't believe it was something that simple. Although our IT department probably won't thank you. Our current organization is the result of merger a few years ago. Use of the # was what they came up with to distinguish between files from the two previously separate entities. Someone is going to have a lot of cleaning up to do. Thanks again.
    Reply With QuoteRegister To Reply
  15. 12-18-2018, 12:04 PM #15
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Problem creating a hyperlink to a file

    Glad i could help, I learned something new as well!
    Thanks for the rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Apostraphe in file path for hyperlink target a problem?
    By mlewis715 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2016, 06:11 PM
  2. [SOLVED] Crating a formula when a value is exceeded
    By Nick1966 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-15-2014, 06:50 AM
  3. Crating pivot tables using Loops
    By booo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2010, 06:47 PM
  4. help in crating a macro
    By shishirnaik55 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2009, 03:21 AM
  5. Hyperlink to jpg file Problem
    By Marcelo in forum Excel General
    Replies: 3
    Last Post: 08-26-2005, 10:05 AM
  6. [SOLVED] Help crating a formula with various arguments
    By GretPR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2005, 07:06 PM
  7. [SOLVED] Problem with hyperlink to .pdf file....please help.
    By sueshe in forum Excel General
    Replies: 1
    Last Post: 04-01-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1