I am currently having an issue where I am using excel web services to open up a workbook in an InfoPath Form, however I get an error saying I cannot open workbooks with data validation in it.
From what I have read around the internet, there seems to be no workaround to this, and the excel spreadsheet must have data validation in it.
Is there any other method of retreiving excel data and placing it in InfoPath?
Thanks,