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.