Cannot Locate Internet Server Or Proxy Server Excel 2011

  • Fix Internet Proxy Server Setting Errors in Windows PCCode: netsh int ip reset resettcpip.txtFacebook Page: on twitt.
  • Hi all, I'm fairly new to using excel, and could really use some help. My problem right now is as follows: I have a given date. I want a cell to return the date that falls 6 months before the given, and turn red if that returned value is 6 months away (or less) from today's date.
  • Cannot Locate Internet Server or Proxy: Web Query. Sun; Oct 6th 2006.
Cannot Locate Internet Server Or Proxy Server Excel 2011
Article ID:218153
Last Review:January 24, 2007
Revision:3.3
This article was previously published under Q218153
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry

SYMPTOMS

When you create a hyperlink in an Office document and then click the link, you may receive the following error message
Unable to open <URL>. Cannot locate the Internet server or proxy server
where <URL> is the hyperlink that you inserted.
NOTE: The hyperlink does work if you type it directly in the browser or in the Open box of the Run dialog box (click Start, and then click Run).

CAUSE

This problem occurs when the following conditions are true:
You are using Microsoft Internet Explorer:
A proxy server -or-
A firewall that does not allow HTTP requests to be placed on your local network
-and-
Internet Explorer is not your default browser.
-and-
The following registry key is not present or is not set to 1:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0CommonInternet

WORKAROUND

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To work around this issue, either add the Internet subkey, if it is not present, and set the Value data, or if it is present, set the Value data of the Internet subkey.

Adding the Internet Subkey to the Registry and Setting the Value Data

1.Quit any programs that are running.
2.Click Start, and then click Run. Type regedit in the Open box, and then click OK.
3.In Registry Editor, browse to the following subkey:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0Common
Note This registry key is the same for all versions that listed in the 'Applies To' section. This registry key will not be different for the different versions.
4.On the Edit menu, point to New, and then click Key.
5.Name the new subkey Internet.
6.Make sure the Internet subkey is selected. On the Edit menu, point to New, and then click DWORD Value. Add the following registry value:
7.Double-click ForceShellExecute, and then set the Value data to 1. Click OK.
8.On the Registry menu, click Exit.

Setting the Value Data

1.Quit any programs that are running.
2.Click Start, and then click Run. Type regedit in the Open box, and then click OK.
3.In Registry Editor, browse to the following subkey:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0CommonInternet

Note This registry key is the same for all versions that listed in the 'Applies To' section. This registry key will not be different for the different versions.
4.Make sure the Internet subkey is selected. On the Edit menu, point to New, and then click DWORD Value. Add the following registry value:
5.Double-click ForceShellExecute, and then set the Value data to 1. Click OK.
6.On the Registry menu, click Exit.

MORE INFORMATION

If your operating system is Microsoft Windows 2000, you must upgrade the Hlink.dll file. This update is included with Windows 2000 Service Pack 1.
A hyperlink may not go to a Microsoft Word document or a Microsoft Excel worksheet after you use this workaround. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
280680 (http://support.microsoft.com/kb/280680/) Cannot follow hyperlink to Office document
APPLIES TO
Microsoft Office Excel 2003
Microsoft Office Outlook 2003
Microsoft Office PowerPoint 2003
Microsoft Office Word 2003
Microsoft Excel 2002 Standard Edition
Microsoft Outlook 2002 Standard Edition
Microsoft PowerPoint 2002 Standard Edition
Microsoft Word 2002 Standard Edition
Microsoft Excel 2000 Standard Edition
Microsoft Outlook 2000 Standard Edition
Microsoft PowerPoint 2000 Standard Edition
Microsoft Word 2000 Standard Edition
  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.
  • Print this page
  • E-mail this page
  • Microsoft Worldwide
  • Save to My Support Favorites
  • Go to My Support Favorites
  • Send Feedback

Cannot locate the Internet server or proxy server where is the hyperlink that you inserted. NOTE: The hyperlink does work if you type it directly in the browser or in the Open box of the Run dialog box (click Start, and then click Run ). If a proxy server changes IP addresses randomly for security reasons, this will prevent a download connection from being maintained and the download will not commence. If you are still having difficulties downloading, see if your workplace has a dedicated machine with open access to the internet that bypasses the proxy server.

Cannot Locate Internet Server Or Proxy Excel

Cyber attacks may not be a new phenomenon but the recent successes scored against high-profile targets including CitiGroup, Google, RSA and government contractors such as Lockheed Martin underscore the targets' current failure to block security threats enabled by the Internet. Malicious hackers use the very same technology that enables online banking, entertainment and myriad other communication services to attack these very applications, steal user data, and then cover their own tracks.
One common practice that attackers employ to evade detection is to break into poorly secured computers and use those hijacked systems as proxies through which they can launch and route attacks worldwide. Although such attacks are an international problem, there is no international response, which frustrates local law enforcement seeking cooperation from countries where these proxy servers typically reside.
Address unknown
Every day seems to bring news of some new cyber attack. 'We're seeing more reports on invasive attacks on a much more regular basis,' says Chris Bronk, an information technology policy research fellow at Rice University's James A. Baker III Institute for Public Policy and a former U.S. State Department diplomat.
The hardest problem in finding the source of these attacks is attribution. Each data packet sent over the Internet contains information about its source and its destination. 'The source field can be changed [spoofed] by an attacker to make it seem like it's coming from someplace it's not,' says Sami Saydjari, president of the cyber-security consultancy Cyber Defense Agency and a former program manager of information assurance at the Defense Advanced Projects Agency (DARPA).
'If your network is under attack and you're trying to find out who's doing it, purely technical means are insufficient for that,' says David Nicol, director of the Information Trust Institute at the University of Illinois, Urbana–Champaign. 'The way that we assemble complicated networks of computers until recently hasn't been done at all with security in mind except in a cursory way, and that's the fundamental problem.'
By way of example, Nicol points out that he uses a virtual private network that connects to a proxy server before connecting him to the Internet. This enables him to encrypt data he sends over the network and protect the identity of his own Internet protocol (IP) address. 'I do this to thwart information harvesting that commercial Web sites usually have,' he adds. 'I've got nothing to hide but that doesn't mean I want information about me harvested and sold.'
Unfortunately, such tactics are also employed for malicious purposes. Cyber attackers use viruses, worms and other malware to take control of Internet servers or even personal computers, creating a network of 'zombie' computers (also called botnets) under their control that they can use to launch their attacks. As a result, an attack may appear to come from a particular server or computer, but this does not mean the attack originated at that device, Nicol says, adding that often a string of proxies located in different countries are used in an attack, 'greatly complicating the legal process of trying to piece it all together.'
Spear phishing
One of the primary methods of creating zombies is by getting computer users to unwittingly infect their computers by opening e-mails and Web pages containing malware. 'If you look at the way RSA was penetrated, it was not terribly sophisticated, nothing on the order of Stuxnet, which was probably the most sophisticated attack we've seen in recent memory,' says Anup Ghosh, a research professor and chief scientist at George Mason University's Center for Secure Information Systems. 'Most of these attacks are executed using conventional exploits. What's different is they're using these exploits in new ways.'
In the case of RSA hackers used 'spear phishing' e-mails to trip up someone within the company, says Ghosh, also the founder and CEO of cyber security technology maker Invincea, Inc. The offending e-mail purported to be a document about staff hiring issues and had been caught by the company's spam filter. The employee opened the e-mail, thinking it had been erroneously quarantined by the filter. The e-mail actually contained an Excel document that, once opened, installed malware on the employee's computer and from there spread to other computers within the company. 'This machine wasn't the target, it was the beachhead,' Ghosh says.
To make matters worse, RSA CEO Art Coviello confirmed earlier this week that information taken from RSA in March had been used as an element of an attempted broader attack on Lockheed Martin.
Possible defenses
There is no shortage of software and services available for trying to prevent cyber attacks. Many approaches involve scanning incoming data for possible malware and screening spam e-mail laden with viruses or containing suspicious messages.
Beyond having better network intrusion detection systems, 'we need a system of cooperative intrusion detection and trace-back among different countries,' Saydjari says. 'That doesn't solve the problem but it narrows it down. Right now, you can trace traffic back to a particular country, but it's very difficult to get any visibility into where within the country the packets originated.'
Another important component of cyber defense is to improve security on the computers themselves. This means operating systems with fewer vulnerabilities—Microsoft distributes dozens of security patches for Windows every month, and that is an improvement over just a few years ago. 'That will decrease the number of zombies and increase the level of difficulty with which adversaries can seize control of computers and do this hopscotching from computer to computer,' Saydjari says.
Perhaps the most effective defense, however, is for computer users to demonstrate some cyber street-smarts. 'You never know what tactic the attackers will take, especially when it comes to spear phishing,' Ghosh says. As a result, it is difficult to keep people from being duped into clicking on spam—thinking it is a message from their bank, a delivery service or someone else they think they can trust—and running the risk of infecting their computers with a virus. 'You can train and train and train users but you're not going to get to zero percent,' he adds.