After logging in to the Excel Extension the connection freezes and doesn't connect.


 Product(s):Keynetix
 Version(s):1.0
 Area:Assist

After logging in to the Excel Extension the connection freezes and doesn't connect.

Issue Summary

If you login to the Excel Extension but it just freezes and doesn't connect you will need to work through the steps below. The process requires registry editing so you may find it better to get IT to complete the task.

Resolution

On the PC, go to Environment Variables

In the top window add a new variable

The variable name should be "VSTO_SUPPRESSDISPLAYALERTS"

The variable value should be "0".

Save the changes.

Run the extension

You should get a error box pop up now when you login.

The GUID in the error will look something like this:

000C03A7-0000-0000-C000-000000000046

So, take note of the GUID displayed in the error message.

Open the registry (regedit)

Browse to HKEY_CLASSES_ROOT\Interface\***GUID NUMBER***

You will see it has subkeys like:

ProxyStubClsid

ProxyStubClsid32

TypeLib

Expand TypeLib and look at its values. There will be 2 values, 1 is another GUID and another is a version number(take note of this version number), like 2.5 or 2.6 or 2.x.

Right click on the new GUID and select "Modify", then highlight and copy the new GUID.

Now browse to:

HKEY_CLASSES_ROOT\TypeLib\***New GUID number***

Once you find it, expand it. You should see a list of versions, delete the versions apart from the one that matches the version you found above.

Then when you run the Extension all should work.