Office 2016 SharePoint 2013
For any SharePoint list, when I click on the 'Export to Excel' button on the 'List' ribbon, I am prompted to download the owssvr.dll file. When it download it will download as owssvr.dll instead of owssvr.dll.iqy. When I try to open owssvr.dll, I get the following error in Excel.
When the file opens, it is only the API information and not the data from the list.
How do I get a SharePoint list to download as a .iqy file instead of a .dll file?