Excel Hyperlinks not working

By 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.


This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Do you have drive L mapped?

by ThumbsUp2 In reply to Excel Hyperlinks not work ...

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?

Collapse -

Drive L

by muy In reply to Do you have drive L mappe ...

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.

Collapse -

Try locating it manually...............

by ThumbsUp2 In reply to Drive L

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.

Collapse -

Manually linking

by muy In reply to Try locating it manually. ...

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!

Collapse -

did you figure this out?

by thickham In reply to Manually linking

im having the same problem... thanks!

Back to Hardware Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums