When a hyperlink created in Excel points to a file in the same folder, the address bar that inserts the hyperlink displays only the file name. If you do not specify a path, a problem arises: when the location of the file where the hyperlink is set changes, the hyperlink fails, and the problem with the following diagram occurs.
1, you can set the hyperlink base to solve this problem. Hyperlinks are based on a summary of file properties, which may be very different for different versions of Office software, as shown here in the 2007 version. Follow the icon to select the file-prepare-attribute.
2, in the file attribute Drop-down, click Advanced Properties.
3, in the attribute summary in the hyperlink base to fill in the previous Connection file directory address.
Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join