The validate option will check the following things SmartConnect Excel Add-In criteria:
|1.||Checks that there is a valid connection to the SmartConnect WCF REST service.|
|2.||Checks that a map id has been selected in the configuration window.|
|3.||Checks that a valid worksheet or named range has been selected in the configuration window.|
|4.||Checks that if an output file has been selected, the selected directory is valid.|
|5.||Checks that a data table can be created from the selected configuration.|
|6.||Checks that columns required for the selected map are present.|
If validation fails the user will receive a message detailing each of the steps above that failed.