SmartConnect Webservice : Data could not be validated

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

When using an Excel sample template with SmartConnect, receiving an error that says “SmartConnect Webservice : Data could not be validated” when you hit the submit button.

You need to enable Automatic Formula calculation in Excel for the templates to work. Click on the Office Button, then the Excel Options button. Then click on Formulas on the left side. In the calculation options, make sure “Automatic” is checked in the Workbook calculation options.

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.