QB Issue Resolution:
I had the same issue and figured out a work around. On the screen you want to export you have to click the Memorize option. Once you memorize that report go to the Reports menu option at the top of the page and select that report which should be listed under the Memorized Reports sub-menu. Note: It will open,even though it is not apparent since you see the exact same screen. NOW you can click on the Excel menu options and they should work.
Resolution for Issue 'cannot export report to excel' available: Yes (Solved).
Source: Intuit Community forum.
cannot export report to excel: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.Support for Quickbooks/QBO
Quickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!
Error Recovery for Quickbooks/QBO [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.
Additional Support Options: