I was given a large Excel workbook with many hyperlinks to Word documents. The problem is that the hyperlinks are still pointing to where the files were originally stored, before they were palced on the flash drive. Both the Excel workbook and the word documents are stored on the same flashdrive.
1. Knowing the flash drive will map to different drive letters depending on the computer it is using, is there a way to make the links work on the flash drive? Is there a way to wildcard the drive letter in the hyperlink?
The user is wanting to keep all files on the flash drive and hand out flash drives to multiple people who will access them on different machines. They want the links to work, no matter where it is plugged in.
1. Knowing the flash drive will map to different drive letters depending on the computer it is using, is there a way to make the links work on the flash drive? Is there a way to wildcard the drive letter in the hyperlink?
The user is wanting to keep all files on the flash drive and hand out flash drives to multiple people who will access them on different machines. They want the links to work, no matter where it is plugged in.
