+ Reply to Thread
Results 1 to 2 of 2

Hyperlinks in Excel 2007 - Cannot open the specified file.

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Hyperlinks in Excel 2007 - Cannot open the specified file.

    I received a USB drive from a client with an Excel spreadsheet with hyperlinks to PDF's (not sure of the version it was originally created in but my version is 2007). The PDF's are in another folder on the USB drive. The cells with the hyperlinks have a formula to hidden cells [i.e. =HYPERLINK(C17,B17)] - in column B is the name of the hyperlink and in column C looks to be the file trial to the PDF (please see attached picture). When I select the link, I get an Alert Box stating, "Cannot open the specified file." Do you have any idea of how I can get these links to work? Thanks!

    Excel Hyperlinks.png

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Hyperlinks in Excel 2007 - Cannot open the specified file.

    The full filepath needs to appear for the link to be valid.

    You could use a cell("filename") formula in conjunction with mid or substitution to rewrite all of the hyperlinks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to open multiple PDF files behind hyperlinks in Excel 2007
    By Hollandaren in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-31-2013, 07:27 PM
  2. Trying to open multiple PDF files behind hyperlinks in Excel 2007
    By Hollandaren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 08:29 AM
  3. Replies: 2
    Last Post: 10-22-2012, 09:55 AM
  4. Replies: 10
    Last Post: 06-07-2012, 09:17 AM
  5. VBA for excel 2003. Open file dialog box, open 2007 file xlsx, continue with code
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 12:12 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1