If you are running the latest versions of Microsoft Excel and recently had an automatic upgrade from Microsoft, you may experience a problem in downloading results to Excel, which causes an apparently blank download with no error message displayed.
This problem has been brought on by a Microsoft patch which was released in July.
Microsoft made a change in the behavior of certain file types to increase security. This change came in the security updates KB3115262, KB3170008, and KB3115322. Previously, when you tried to open an HTML or XLA file with an .XLS file extension from an untrusted location, Excel would warn about the mismatch between the file extension and content, but would still open the workbook without Protected View security. After the security up
To get around this problem you have 2 options.
1. Download and save as a .csv and open in Excel.
2. Download and save as .xls , then right click it, click Properties, and then click Unblock next to the "This file came from another computer and might be blocked to help protect this computer." warning. After doing this, the file can be opened as before.