Microsoft office Excel encountered error

Asked By 10 points N/A Posted on -
qa-featured

Hi everyone!

I have things to be done. But this error message always Popup. I am inserting different url in different cells.

When i attempt to click it to go back to the site this error came up. What should i do?

Did i do something wrong?

Please answer this as soon as you see this. I need to do my work.

Thank You in Advance!

Cannot download the information you requested

SHARE
Answered By 10 points N/A #132547

Microsoft office Excel encountered error

qa-featured

Hello Jabez,

To resolve the issue you are getting, you will need to do the following:

  • First, you will need to edit the web page from the place that you are pulling your data from.
  • After that you will have to get rid of the no-cache header. The meta tag you will be looking for looks as follows:
  • HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">

Another workaround will be as follows:

  • You can choose to direct the client computer in order to set Internet Explorer option so that it can bypass the no-cache check for SSL sites.
  • You will do that by going to  START and then in the RUN line you will need to type REGEDIT.
  • After that you will go to the registry and then navigate to HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionInternet Settings.
  • You will right click Internet Settings and after that left click New > DWORD Value (32-bit).
  • You will need to name the new value “BypassSSLNoCacheCheck” without the quotes.
  • After that you will double click the value and give it a value of 1. After that retry the web query.

Regards,

Carl

Related Questions