Installing Excel Connector for Deep Space

Firstly, install Visual Studio Tools for Office Runtime.

Then, install the Excel Connector.

You should now restart Excel.

Troubleshooting Connection Errors


Depending on your IT administration, you may experience errors like:

  • Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

  • Connection attempt failed. Reading from the stream has failed.

Solution 1:

Refer to this link to ensure connectivity is available on your network.

Solution 2:

In Excel ribbon, ensure that you click "Enable Content" in the External Connections have been disabled area. Then, try the connection again.

Solution 3:

Because SSL is not required, we can turn off SSL by appending "SslMode=None" to the connection string.

Set Use SSL to "No" on SSL tab:

Under Advanced, add SslMode=None as shown: