Excel Add-in for SmartConnect produces no results

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When running a SmartConnect map via the Excel Add-in, nothing happens. No errors, warnings, or messages occur. The same map runs fine from the same machine when run via SmartConnect.

Check to see if the Windows Firewall is enabled. If the firewall is enabled you need to add an exception for port 5556. The SmartConnect Excel Add-in sends the data via a SmartConnect web service running on port 5556. If the Windows Firewall is not configured to allow traffic via this port, the Excel Add-in will not work.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.