Shulou(Shulou.com)06/02 Report--

Hyperlinks placed in Excel on shared servers automatically change link paths.

It was\\10.20.100.20\gem\software, and suddenly it became../ software!

The possibilities are as follows:

(Text taken from Microsoft Knowledge Base, KB813914)

Symptoms:

If you create an Excel workbook, PowerPoint presentation, or Word document that contains hyperlinks to other files shared with external documents or networks, the hyperlinks may not work when you open the document again. Open the Hyperlink dialog box, and an extra "../" may have been added to the front of the relative hyperlink path "。

Reason:

This problem can occur when the following conditions exist:

Files are shared to the root share location, but under different folders.

Files linked to are located in folders closer to the root share than the files in which the hyperlink was created.

The path and file name you type before saving a document, workbook, or presentation contain characters that do not match the case of the path and file name of the target document.

In these cases, the following phenomena will occur:

Hyperlinks do not convert correctly to relative links. Because the document has not been saved, Excel or PowerPoint does not have a base reference that can be used to create a relative link reference correctly.

Typing hyperlinks in lowercase characters may cause links to fail when accessing UNIX-based shares and other case-sensitive shares for file names and paths

Alternatives:

To resolve this issue, use one of the following two methods.

Note Before using any of the following methods, you should always save a document, workbook, or presentation before creating hyperlinks to other files in that folder. This creates the base references necessary for creating relative hyperlinks.

Method 1: Manually Set File Location

When creating a hyperlink, do not type the path, but use the Link to File dialog box to create the hyperlink:

On the Insert menu, click Hyperlink.

In the Link To dialog box, click Existing File or Web Page.

Click Browse Files.

Type the path to the network share, and press ENTER to list the contents of the share.

Click the file you want to hyperlink to.

Click OK, and then click OK.

Method 2: Disable Update Link on Save

This method prevents PowerPoint or Excel from modifying links that have already been created and prevents possible damage to link formatting.

On the Tools menu, click Options.

Click the General tab.

Click Web Options.

Click the Files tab.

Click to clear the Update links on save check box and the Manage supporting files with folders check box.

Click OK.

Status:

Microsoft has confirmed that this is a vulnerability in the Microsoft products listed at the beginning of this article

The first method was obviously a stopgap solution, so choosing the second method could basically cure the problem!

But how do you modify the link path that was previously modified?

This has to be changed manually.

But if manual one by one in excel form to change, then it is very painful! Like my excel form there are tens of thousands of link paths need to change, it is estimated that a week is not done!

Actually not, because if it is placed in the shared server excel link path change, basically the things are the same! So if there is a way to directly find the change path, and then use the alternative way to make changes will be a lot of convenience ~!

Open Tools-Macros-Microsoft Script Editor (may require installation).

Here you can see a large number of scripting languages, and then find the change path, and then select, and use the replacement project, the wrong link path will be changed to the correct link path ~!

I hope I can give you some help!

If you have any better way, please don't be stingy, let me know!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.