I was on the phone with Intuit for 3 hours on Thursday and they were unable to solve this:
We were required to upgrade Outlook 2010 to Outlook 2021 to satisfy the requirements of our email archiver. I installed MS Office 2021 Home and Business to get Outlook 2021, which means I also got Excel 2021. When the new Excel installed, it broke the link between QuickBooks 2023 and Excel. I uninstalled QuickBooks, rebooted, and then reinstalled QuickBooks2023, thinking it would find the new Excel in the install process and reestablish the link. Nope! From the Reports menu I can email a .pdf. QuickBooks creates the .pdf from a memorized report, and then opens Outlook with the .pdf as an attachment. I cannot do the same when I request QuickBooks email that same report as an Excel spread sheet. I get a report that says "Error Excel cannot be opened." Nor under Reports can I get QuickBooks to create an Excel spreadsheet. Same error msg. Yesterday. I uninstalled QuickBooks 2023 again. Then I renamed all the Intuit directories I could find under C:\Program Files and C:\Program Files(x86) to Intuit.old so it wouldn't access them during the reinstall process and hopefully solve the problem. Nope same error. "Excel can not be opened." Excel works just fine. I can create a .csv file from the reports menu, that I can then double click on and it will automatically open in Excel 2021.
So then I uninstalled Microsoft Home and Business 2021 and rebooted. Then reinstalled MS Office. Then uninstalled QuickBooks 2023 again renamed the Intuit directories to .old. Rebooted. Then reinstalled QuickBooks2023. Still the same problem. "Excel cannot be opened." QuickBooks support has been unhelpful. After trying all the simple fixes I've already done on my own, I've been left on hold until I was forced to give up. Is there a developer out there who knows how the link to Excel is established during the install process? Is there a registry key that can be edited? There must be someone who knows.
