You may discover that you can no longer open Excel files that have been downloaded from Query Wizard. This is related to the security vulnerability patches that Microsoft released on July 12, 2016. Included in the patches released that day is a patch that prevents users from opening files directly from the internet when prompted to Open or Save.
โ
Workaround:
When prompted to Open or Save the file, click Save.
Select Save As.
Save the file to any location you desire in your file system.
Navigate to the location in the file system and open the file from there.
You may be warned that the file is corrupted. It is not. This is referencing the HTML present in the file.
โย
An alternative is to download the file as a .csv, which automatically strips out all formatting.
For more information on the different ways you can save your Query Wizard results, click here.