Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011

    Unanswered: Hyperlinks "Cannot open file"

    Dear all

    I am using Excel 2003 and I am using a hyperlink to link to other spreadsheets in different folders and drives.

    When I create the hyeprlink it works great first time. I then save and close the document containing the hyperlinks

    When I re-open the spreadsheet and click on the hyperlink I am met with the message "Cannot open file"

    Does anyone know why I can no longer thne open the hyperlink and why the link may be broken?

    Many Thanks for any advice


  2. #2
    Join Date
    May 2012
    Try this.

    File->Properties->Summary Tab->Hyperlink Base
    Change it to something that's always available E.g. C:\

  3. #3
    Join Date
    Jun 2012
    Generally such problems will occur when you change the file location. So make sure that those files which you hyper linked in your excel sheets are at same place. If you change their location then you have to change hyper links as well.

    Also, there is a chance that those files were got corrupted so please scan those files with an updated anti-virus software.

Posting Permissions

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