This is incredibly pathetic and embarrassing on Intuit's behalf.

How has it been years worth of these complaints and not a single compatibility solution has been implemented.

Its insane that you can't open QuickBooks Settings and specify an Excel/Office installation. Absolutely insane. Extremely pathetic and shameful support/development.

We manage IT for numerous clients who have QB. Everytime they update office they also have to completely fresh install QB? Do you know how insanely moronic and time consuming that is?

Please be better this is unbelievable that I found this thread from years ago and there's still the exact same non-solution being offered.

"Oh idk, I guess reinstall." WHAT!?!? 

This is incredibly pathetic and embarrassing on Intuit's behalf.

How has it been years worth of these complaints and not a single compatibility solution has been implemented.

Its insane that you can't open QuickBooks Settings and specify an Excel/Office installation. Absolutely insane. Extremely pathetic and shameful support/development.

We manage IT for numerous clients who have QB. Everytime they update office they also have to completely fresh install QB? Do you know how insanely moronic and time consuming that is?

Please be better this is unbelievable that I found this thread from years ago and there's still the exact same non-solution being offered.

"Oh idk, I guess reinstall." WHAT!?!? How did you seriously consider this to be a "solution". 

Thank you, this finally worked for me too, with a slight modification.

Running QB 2020 Desktop Premier, I upgraded to Office 365 from Office 2010. Didn't like it and uninstalled 365, reinstalled 2010. Excel Export would not work no matter what I did. Checked the registry key mentioned here - I didn't find 1.9, but I had 1.7 and 1.8. 1.7 refers to Excel 14.0, which is the version number of Office 2010, so I left it alone. 1.8 referred to Excel 15.0. I deleted that entire 1.8 key. Problem solved.

This doesn't work for me either, these options are all greyed out and I am unable to change them.

I did this and it erased all my microsoft office apps and now I have to figure out how to reinstall them.

Hi, @mwyld. 

Let me help you reinstall your Microsoft Office and troubleshoot the issue about exporting from QuickBooks Desktop (QBDT) to Excel.

To provide better assistance, can I ask which options on your end are greyed out? It would also help if you could add the current version of your QBDT and Microsoft Office.

In the meantime, refer to this website for the steps to reinstall your Microsoft Office: Download and install or reinstall Microsoft 365 or Office 2021 on a PC or Mac. However, if you still need further assistance, I'd recommend contacting their support team: Microsoft Support. 

Since each version of QuickBooks Desktop works with specific versions of Microsoft Office, you can consider reinstalling the earlier version of MS Office that worked with your current version of QBDT in the meantime to continue with the exporting process. 

After this, let me add this article about exporting MS Excel files from QBDT as a guide: Import or export MS Excel files.

Let us know how the MS Office reinstallation process goes. We'll be here to offer ongoing support. Take care.