Ref to PDM 2016 version, I am able to configure Excel and also able to retrieve the value when query from card list within PDM administrative window but as soon I used the list in Card then it shows as "Error executing card list query".
As the server is 64 bit so below input is mentioned while adding excel as a linked server
Provider- Microsoft Office 12.0 access database engine OLE DB provider
Product Name- Excel
Data source - D:\------\----.xlsx
Provider String - Excel 12.0
All works fine but when I use list in card, I receive the error.