Hello there, Gazzam.

I'm here to help ensure you can export reports QuickBooks Desktop (QBDT) reports to Excel.

You should be able to export your reports since your QBDT version (2016) is compatible with Microsoft Excel 2013, 2010, or 2007. To isolate this, we can perform other troubleshooting steps aside from updating the software. Let's run the built-in Rebuild and Verify tools. It allows your QuickBooks software to refresh the data inside the company file.

Before we proceed, please note that these steps may or may not work because the version of QBDT you're using is already discontinued or unsupported version.

Here's how to do it:

1. In QBDT, go to the File menu, then hover over Utilities and select Rebuild Data.
2. On the QuickBooks Information window, select OK. Follow the onscreen steps to save a backup.
3. Let the tool repair your file. It may take some time. QuickBooks may seem stuck, but as long as you can move your mouse, the tool is working.
4. When the tool finishes, select OK.
5. Go to the File menu. Then hover over Utilities and select Verify Data.
6. Let the tool check your file for data issues.

If QuickBooks doesn't find any problems, select OK. You can keep using your company file. You don't have any data damage. If it finds an issue, select Rebuild Now.

If the same thing happens, check out this article and proceed to Solutions 2 - 4 for more troubleshooting steps: Fix data damage on your QuickBooks Desktop company file.

Once done, try to export the reports again to double-check. Refer to this article for further guidance: Export reports as Excel workbooks in QuickBooks Desktop.

Leave a comment in this thread if you have follow-up questions about this or anything else QuickBooks. I'll be here to help. Take care always.