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
Bookmarks