Microsoft office Excel encountered error

Microsoft office Excel encountered error

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