Closed Thread
Results 1 to 5 of 5

Hyperlink File Path Too Long?

  1. #1
    Registered User
    Join Date
    01-20-2005
    Posts
    5

    Hyperlink File Path Too Long?

    I have a database saved as an excel spreadsheet that includes hyperlinks to AutoCAD drawings on my hard drive.

    My database worked fine until I recently decided to reorganize my files into more specific folders. Now, when I update my hyoerlinks to the newer and longer file paths, they don't work.

    An example of an old file path is:
    C:\Program Files\AutoCAD LT 2000\Drawing Files\Avalon Hse\BLSouth\BLSAva51FBA001FTG.dwg

    The same file at its new address is as follows:
    C:\Program Files\AutoCAD LT 2000\Drawing Files\Avalon Hse\BLSouth\FBA\Version #5\BLSAva51FBA001FTG.dwg

    When I use the hyperlink function, it works fine using my old path, and it gives me an error with the new path that reads "cannot find specified file." I am positive that the file path is spelled accurately as I copied and pasted it from the path in Windows Exploer that points to the given file.

    Is there something in Excel that limits the length of a file path in hyperlinks? I sure hope there's a way for me to get this database working without having to go badk to my old filing system.

    Jearshub
    Last edited by Jearshub; 01-20-2005 at 06:37 PM.

  2. #2
    Registered User
    Join Date
    01-20-2005
    Posts
    5
    The problem I posted pertains to my work computer. I'm not there now. But I believe the version we have there is Excel 2000.

    Jearshub

  3. #3
    Registered User
    Join Date
    01-20-2005
    Posts
    5
    I have seen other hyperlink threads in this forum that relate to the "cannot open file" message., but none seemed to parallel my problem....
    Am I the only one who has run into this?
    Anybody have any thoughts?

  4. #4
    Registered User
    Join Date
    01-20-2005
    Posts
    5

    Somebody HELP!

    Sorry for continuing this thread. But I'm sure somebody on this forum knows exactly what I should do.

  5. #5
    Registered User
    Join Date
    01-20-2005
    Posts
    5

    Answer

    Ok, well I didn't get a reply from any of you. But I figured out what was wrong. My new hyperlinks included "#" in the file paths. Apparently Excel doesn't like that. I'm not sure why, since the whol path is in quotation marks. But that was definitely the problem.

    I have already fixed it for this case by just changing the names of all my directories, taking out the # signs.

    However, I'm sure there must be a way to force Excel to follow a file path with a "#" in it. Anybody know how?

Closed Thread

Thread Information

Users Browsing this Thread

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

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