Questions

Excel Hyperlinks not working

+
0 Votes
Locked

Excel Hyperlinks not working

muy
Can someone please inform me as to what is the cause of my hyplerlink not working.

Up until a week ago the links were fine, but its not longer working.

The excel sheet has links within them that point to a another excel sheet that resides on a network drive.

When I click to open the link I am returned with the following "Cannot open specified file"

This is the link that the cell needs to point to and open: ='L:\Production\Fabric Warehouse\Cue fabrics\2057\[2057.xls]DATA ENTRY'!B2

Can someone please tell me what can be the cause of it not opening. Other people on the network are able to open the hyperlinks just fine with no problems.

Thanks
  • +
    0 Votes
    ThumbsUp2

    It's looking for files on drive L. Is the drive the file is pointing to mapped AS drive L on your computer and do you have access to it?

    +
    0 Votes
    muy

    The computer is networked so at login the computer is mapped to drive L and other network drives.

    The folder in with the excel files can be located in L drive but when I click on the hyperlink set up in excel it doesn't open the other the excel workbook.

    +
    0 Votes
    ThumbsUp2

    Try using Windows Explorer to locate the file manually, navigating the exact path that is specified in the link. Look for spelling and even capitolization differences as you traverse the path. See if you can get to the spreadsheet manually, then open it and look to make sure there is a sheet named exactly like what's in the path.

    If you can get to it that way, we'll work on the next step.

    +
    0 Votes
    muy

    Done! Still not opening the link.

    The thing is that excel will open up the other excel worksheet if i go to Tools, Links and manually select the workbook to open from the list. There is no problems with the other worksheets, its just the hyperlink not wanting to open.

    On other PC the excel worksheet opens the hyperlinks fine!

    +
    0 Votes
    thickham

    im having the same problem... thanks!

  • +
    0 Votes
    ThumbsUp2

    It's looking for files on drive L. Is the drive the file is pointing to mapped AS drive L on your computer and do you have access to it?

    +
    0 Votes
    muy

    The computer is networked so at login the computer is mapped to drive L and other network drives.

    The folder in with the excel files can be located in L drive but when I click on the hyperlink set up in excel it doesn't open the other the excel workbook.

    +
    0 Votes
    ThumbsUp2

    Try using Windows Explorer to locate the file manually, navigating the exact path that is specified in the link. Look for spelling and even capitolization differences as you traverse the path. See if you can get to the spreadsheet manually, then open it and look to make sure there is a sheet named exactly like what's in the path.

    If you can get to it that way, we'll work on the next step.

    +
    0 Votes
    muy

    Done! Still not opening the link.

    The thing is that excel will open up the other excel worksheet if i go to Tools, Links and manually select the workbook to open from the list. There is no problems with the other worksheets, its just the hyperlink not wanting to open.

    On other PC the excel worksheet opens the hyperlinks fine!

    +
    0 Votes
    thickham

    im having the same problem... thanks!