I saved the excel (*.xls) to (*.xlsx) and rebind every single test that is bind to a test since it is actual a different file.
What I did exactly was:
- Copy *.xls files to another folder
- Open the *.xls
- Save the *.xls to *.xlsx
- Open Telerik Test Studio
- Remove Data Binding for every test related to the data source (right click on test in project explorer which has a binding)
- Go to Manage
- Remove the *.xls
- Press + to add new datasource (choose *.xlsx)
- Select test you want to bind to a datasource
- Go to Bind Test
This should be done for every test that has a binding with that data source. You should remember the binding rows and tables you choose before and set that.
@Elena: This is very cumbersome so it would be nice if this will be fixed as soon as possible because we need to change all bindings. If it was only the files that needed to be changed it wouldn't really matter. Could you maybe investigate this issue in combination with the update of Microsoft Office that took place at 11th of October?
Probably either one of the updates below caused the issue:
Update voor Microsoft Excel 2016 (KB4011166) 32-bits editie
Update voor Microsoft Office 2016 (KB4011167) 32-bits editie
Beveiligingsupdate voor Microsoft Office 2016 (KB2920723) 32-bits editie
Beveiligingsupdate voor Microsoft Office 2016 (KB4011185) 32-bits editie
Thanks and regards,