When a hyperlink is opened in Excel, the system prompts that http:/xxxx cannot be opened. You cannot download the required information.

An error is reported, as shown in figure

650) This. width = 650; "Title =" qq 40708213814.jpg "alt =" wKiom1O79d2Dg-7XAAPPtvB7Ivo000.jpg "src =" http://s3.51cto.com/wyfs02/M01/3A/A5/wKiom1O79d2Dg-7XAAPPtvB7Ivo000.jpg "/>

Reference the analysis of the following Buddy:

Http://blog.chinaunix.net/uid-7654720-id-1742038.html

"

1) enter the link address in IE to view the link normally. However, not all links in Excel cannot be accessed directly. In combination with these two points, there are no problems with the website server, ie, and Excel, and there is no problem at all. The problem is probably due to the "cooperation" issue between them.

 

2) Enable the "packet capture" software on the computer (Wireshark is used here), click the inaccessible link in Excel, and view the captured result, client (my computer) after three TCP handshakes are established with the server, the client initiates an HTTP request. The request header is as follows:

Get, HTTP, 1.1

Accept :*/*

User-Agent: Mozilla/4.0 (compatible; msie6.0; Windows NT 5.1; svc1; Ciba;. Net CLR 2.0.50727)

HOST: www. ****. com

Connection: keep-alive

COOKIE :**************

 

At the same time, you can directly access the Link (http: // www. ****. com), use httpwatch to capture packets (you can also use the packet capture tool to capture packets. It is more convenient to use httpwatch here. In addition, in Excel, you can directly open the link. in IE, httpwatch cannot directly find the "problematic" link package, because you cannot click the link in Excel to open the IE window, therefore, the package on the previous page must use the packet capture tool Wireshark to obtain the access content ). The request header is as follows:

Get, HTTP, 1.1

Accept: image/GIF, image/X-xbitmap, image/JPEG, image/pjpeg, application/X-Shockwave-flash, application/MSWord, application/vnd. MS-Excel, application/vnd. MS-PowerPoint ,*/*

Accept-encoding: gzip, deflate

Accept-language: ZH-CN

Connection: keep-alive

COOKIE :**************

User-Agent: Mozilla/4.0 (compatible; msie6.0; Windows NT 5.1; svc1; Ciba;. Net CLR 2.0.50727)

 

This is an accessible request header, compared to the request header in "Excel mode.

The accept-language: ZH-CN field is added.

 

Through this step, we can see that the problem is located, and then verify it.

 

3) Verify 2) the information obtained from the analysis.

Telnet www. ****. com 80 and then use the following header to send the request:

Get, HTTP, 1.1
HOST: www. ****. com

The result is that the page content cannot be obtained.

 

Use the following header to send the request

Get, HTTP, 1.1
Accept-language: ZH-CN
HOST: www. ****. com

The result is the correct page content.

 

Some can be inferred ":The Link opened in Excel cannot be opened directly by means of a link. The parameters set for character encoding in the web program on the server or in the page are "incompatible" with the requests sent in Excel ".

"

The solution comes from the KB of Microsoft n long ago. The white boss can find and test the solution.

Http://support.microsoft.com/kb/218153/en-us

Note: The content in the Chinese case is not updated, and the Registry path may be incorrect.

The Fixit tool in the solution is not applicable to the current version of Office. However, the manual modification method is normal.

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Office \ xx.0 \ common \ Internet

Create a DWORD Value forceshellexecute and set it to 1

 

This article is from the foolishfish blog, please be sure to keep this source http://foolishfish.blog.51cto.com/3822001/1436056