On 10/12/2017, Microsoft released an update for MS Office which caused exporting to Excel to fail with an error similar to the following:
There is are a couple of possible solutions for this, and at least until Microsoft release a patch to fix this issue:
- You can export your files to CSV
- You can export your files to XLSX (if that is an option)
- You can restore the problematic file which is the least intrusive, and reverts you back to a working scenario. Please see the instructions below to do so:
How to restore the export functionality for Excel exports:
- .Get a copy of the file: msexcl40.dll. You need version 4.0.9801.0. You can download that file here. (This file is for Excel 2013) Or if you don’t trust this link, you can simply grab the file from a machine with a clean install of MS Excel, before any Windows updates are applied. The file can be found in C:\Windows\SysWOW64\msexcel40.dll
- Rename the same file in C:\Window\SysWOW64\msexcl40.dll to msexcl40.old. This file should have the version: 4.0.9801.1
- Place the new file you just downloaded in its place. You might need to reboot, and when Excel launches, it might also ask you to re-activate over the internet. Allow it to do so.
- Alternatively, if you would like to leave the original dll intact, you can place the new dll anywhere on your system, and change the path to it in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel\win32
Update: October 17, 2017
Microsoft has identified this as an issue with a recent Windows update, and are working to resolve it, For more information, you can view this article from Microsoft. They will provide an update in an upcoming release to resolve this issue.