Cannot Locate Internet Server Or Proxy Server Excel 2011

  

  • Points
    8
    Trophies
    1
    Posts
    2

    Currently my company is importing the data to excel spread sheet from the following website http://www.pjm.com/pub/account/lmpgen/lmppost.html and the data is displayed to the price board. It runs 24/7 and it refreshes data every minute.


    It was set up thro’ the web query, and there is no macro involved in importing.


    Whenever there is a problem with website, it gives the following error


    “Unable to open http://www.pjm.com/pub/account/lmpgen/lmppost.html. Cannot locate the Internet server or proxy server.’


    Until someone clicks OK to the error message, the web query stops importing and the price board gets freezes.


    I tried with the following macro to avoid the error messages being poped up.

    1. Sub Auto_Open()
    2. Application.DisplayAlerts = False
    3. End Sub


    But it did not help.


    Is there any way to suppress the error message and start the refresh once again?

    1. Navigation
    2. OzGrid
    3. Forum
    4. Members
    5. Options
    6. Current Location
    This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
    Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

The issue happens in Microsoft Word, Microsoft, Excel, Microsoft PowerPoint and Microsoft Outlook applications. 'Cannot locate the Internet server or proxy server. Having problems inserting hyperlinks into a word doc ebook on my Mac Word 2011. Tried all variations of the insert hyperlinks but just keep getting message. Unable to open - Cannot locate the internet server or proxy server. When you create a hyperlink in an Office document and then select the link, you may receive one of these error messages: Unable to open. Cannot locate the Internet server or proxy server. Contacting the server for information. I have an excel file that has been 'Contacting the server for information' FOREVER. I finally have gotten fed up with it and broke down my very large excel file to one workbook that is causing the issues. However i can not FIND (code) causing this message. I have deleted ALL macros. But its still happening. Question: Q: Cannot locate the internet server or proxy server I am using MacOS Mohave 10.14, Safari 12.0, and MS Office for Mac 2011 14.7.7. When paste a website link into MS Word or MS Excel, then try the link, I get this message: 'Cannot locate the internet server or proxy server'.

If you are getting “Unable to Connect to Proxy Server” message on your computer, you will find below the steps to fix this error in Windows 10.

Unable to Connect to Proxy Server in Windows 10

If you are seeing “Unable to Connect to Proxy Server” Error in Windows 10, the reason is usually due to misconfiguration in proxy settings on your computer.

If you are using a Proxy server or VPN, this error can be fixed by making corrections as required for the VPN settings on your computer.

If you are not using a Proxy Server (VPN), you can fix this error by disabling the option to use Proxy Settings on your PC and scanning your computer for malware.

Apart from faulty Proxy settings, this error can also be caused by network and browser related problems.

1. Disable Proxy Settings

If you are not using Proxy Server or VPN, you should be able to fix the error by disabling proxy settings on your computer.

1. Open Settings and click on Network and Internet tab.

2. On the next screen, scroll down and click on Proxy in the left-pane. In the right-pane, scroll down and uncheck Use a Proxy server option.

Make sure that ‘Address’ and ‘Port’ Fields under ‘Manual Proxy Setup’ section are empty.

After disabling Proxy server, open the web browser on your computer and see if you are able to connect to internet.

2. Reset Internet Options

Cannot Locate Internet Server Or Proxy Server Excel 2011Cannot

Unable to connect to Proxy Server error in Windows 10 can also be caused by change in internet settings.

Locate

1. Right-click on the Start button and click on Run.

2. In Run Command window, type inetcpl.cpl and click on OK.

3. On internet properties screen, select Advanced tab and click on the Reset button.

4. On the next screen, check Delete Personal Settings option and click on Reset.

Restart your Computer and see if you are still getting “Unable to Connect To Proxy Server” Error on your computer.

3. Clear Browser Cache

Clear the browser Cache on your computer to rule out the possibility of old cached web pages being served by the web browser.

1. Open Chrome browser > click on 3-dots menu icon > More Tools > Clear Browsing Data.

2. On the next screen, set All Time as the ‘Time Range’ > check Browsing History, Cookies and other site site data, Cached images and files options and click on Clear Data button.

After Clearing Browsing Cache, see if you are able to connect to internet.

4. Flush DNS and Reset IP

1. Right-click on Start button and click on Command Prompt (Admin).

Cannot Locate Internet Server Or Proxy Excel

2. On Command Prompt screen, type the following Commands one-by-one and hit the enter key after each command.

  1. ipconfig /flushdns
  2. netsh int ip reset
  3. netsh winsock reset

After executing above Commands, Restart your computer.

5. Reset Chrome Browser

1. Open Chrome browser on your computer.

2. Click on 3-dots menu icon and select Settings option in the drop-down menu.

3. On Settings screen, scroll down to bottom and click on Advanced.

4. On the next screen, scroll down and click on Restore Settings to their original defaults option, located under ‘Reset and clean up’ section.

5. On the confirmation pop-up, click on Reset Settings button to confirm.

6. Scan Computer for Harmful Programs

Google’s Chrome browser comes with an in-built tool that can help you find and remove harmful programs on your computer.

1. Open Chrome > click on 3-dots menu icon > Settings > Advanced.

2. Scroll down and click on Clean up computer option located under “Reset and Clean up” section.

Cannot Locate Internet Server Or Proxy Server Excel 2011 Full

3. Next, click on Find to allow Chrome browser to start searching for harmful programs on your computer.

If Chrome finds harmful or suspicious programs click on Remove and follow the instructions to remove the program.

You can also use the Antivirus program installed on your computer or use Windows Defender offline scan to check your computer for malware and harmful programs.

Cannot Locate Internet Server Or Proxy Server Excel

7. Check Proxy Server Settings

If you are using a Proxy Server or VPN to connect to the internet, check the VPN Settings on your computer and make corrections as required.

Internet

Cannot Locate Internet Server Or Proxy Server Excel 2011 Version

1. Open Settings and click on Network and Internet.

2. On the next screen, click on VPN in the left-pane. In the right-pane, click on VPN Name > Advanced Options.

Cannot Locate Internet Server Or Proxy Server Excel 2011 Download

3. On the next screen, make sure your VPN Name, Address and other required details are correct. If not, click on the Edit button.

Cannot Locate Internet Server Or Proxy Server Excel 2011 Free

4. On the next screen, Enter Correct VPN Name and Address.

After correcting Proxy Settings, you should be able connect to internet using VPN settings on your computer.