QuickBooks export to Excel grayed out Office 365

Problem: When you try to export from Intuit QuickBooks to Microsoft Excel you get one of the following errors such as Excel cannot open the data file or Excel option is grayed out in reports menu. Affected Systems: QuickBooks 2020, QuickBooks 2019, [...]