Won't Fix
Last Updated: 17 Oct 2018 18:05 by Herb
Created on: 16 Oct 2017 12:20
Type: Feature Request
Unable to select table of excel data source due to Windows update
Multiple customers reported that after applying a Windows update KB4041676 on a windows 10 system all excel files bound as data source in a Test Studio project stopped working as expected - the file stayed bound but no tables appear to select any of these. 

It would be good to investigate what that update causes.
Posted on: 17 Oct 2018 18:05
Try: https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
Posted on: 09 Nov 2017 13:58
Hi Elena,
Can you please let me know the official Microsoft Security Update that fixes the previously introduced issues with Excel files? Currently, I have installed Windows Server 2008 R2 Standard Service Pack 1 64 bit. 
Posted on: 08 Nov 2017 21:10
I am using windows 7 64-bit.
I am facing issue with data-binding with .xls, some one help me which windows update do I need to uninstall.
Posted on: 03 Nov 2017 12:30
Hi everyone! 
There is an official Microsoft Security Update which fixes the previously introduced issues with Excel files. Please find further details here: 
Andy Wieland
Posted on: 30 Oct 2017 17:10
I believe this relates: https://feedback.telerik.com/Project/161/Feedback/Details/200386-excel-datasource-doesnt-work-against-xlsx
Posted on: 25 Oct 2017 15:08
For windows 7 
I found that the Security Update for Windows (KB4041681) was the issue.
After removing, it worked correctly.
Posted on: 19 Oct 2017 02:36
Hello Ivaylo,
I don't have installed Excel. How can I change the DB connection string? Where?
Posted on: 18 Oct 2017 07:39
The problem is related to Microsoft update and we from Test Studio do not have control, please check for more details below and the workaround provided:

Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, “Unexpected error from external database driver (1). (Microsoft JET Database Engine)".

Download and install the Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-us/download/details.aspx?id=13255&751be11f-ede8-5a0c-058c-2ee190a24fa6=True), and then modify the DB connection strings in Microsoft Excel to use ACE as a provider. Example: Change Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0.

Posted on: 17 Oct 2017 13:45
I am experiencing this same issue.  I am using Windows 7, however, so it is not limited to just Windows 10 users.