I tried all of the aforementioned recommendations then eventually found the real fix. 

Office 32 bit version are not working for report exporting so uninstall and reinstall office 365 64 bit edition and send reports to excel will function again.