Let’s get it sorted, @SkyQueen. 

I’m glad that you're still able to create the report manually despite the issue you’re getting. 

Making sure of your version up-to-date and compatible is a guarantee to avoid any error in the future. Since all the possible troubleshooting steps are mentioned here, including repairing Microsoft Office, you can reinstall QuickBooks. The Microsoft Office and Excel need to be installed on your computer before you install QuickBooks.

Once done, try to access the report again. If you’re getting the same results, you’ll want to uninstall and reinstall Excel. You can click this link and follow the steps provided.

You might want to check this article for additional information: Fix export to Excel issues in QuickBooks Desktop.

You can also reach out to our Technical Support team through the phone if the issue persists. So they can check and locate the main cause of this issue for you. Just follow my colleague's instructions above to contact them.

We’re here anytime if you have other concerns with QuickBooks. Keep safe.