Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
New Member
June 16, 2021
Question

Emailing Reports on QB 2019 In Excel Format

  • June 16, 2021
  • 6 replies
  • 12 views

Hello,

 

When I go to the email reports feature and try to email a report in Excel format, I get the following:  

 

"Microsoft Excel could not be opened.  If the problem persists, verify you have the correct version of MS Excel installed on your computer"

 

I have checked online and it says MS 365 should work with QB 2019.  I have tried various fixes including changing my account settings as advised. Nothing works.  Any suggestions??  Thanks So Much!  Patti B

6 replies

Moderator
June 16, 2021

Hello, PattiB2021. 

 

Thanks for reaching out to us. I’ve got some steps to try to fix the export to Excel issue in QuickBooks Desktop. 

 

To start off, let's update your QuickBooks to the latest release. This will help you download the changes, improvements, and fixes that were made to QuickBooks. Here's how:

 

 

  1. Go to the Help menu at the top, then pick Update QuickBooks Desktop on the drop-down.
  2. Select the Update Now tab, then check the box next to Reset Update.
  3. Click Get Updates

 

For your reference, you may visit this article: Update QuickBooks Desktop to the latest release

 

Next, let's run the Verify and Rebuild utility. This tool will fix any errors it can find and notify you of anything that needs to be manually corrected​. You can also check out this article for detailed steps: Verify and Rebuild Data in QuickBooks Desktop

 

Once done, try to export your report again to Excel. If you're still getting the same results, you can repair QuickBooks Desktop to fix program-related issues or errors. 

 

Additionally, Here’s an article for your reference: Fix export to Excel issues in QuickBooks Desktop

 

Please touch base with me if you need further assistance, I'll be here to help you out. Stay safe!

New Member
June 18, 2021

Hi Aileen,

 

I have tried all recommended solutions and none have solved the issue.  If you have any more suggestions, let me know and thank you so much!

New Member
June 18, 2021

Hello there, PattiB2021.

 

It's good to know that you've gone through all those troubleshooting steps to fix it.

 

Since none of the above steps fix it, I'd suggest contacting us. This way, our support team can securely access your account and double-check what's causing this to happen.

 

They will help you determine which additional troubleshooting steps needs to be done.

 

Here's how to reach them:

 

  1. Go to Help menu.
  2. Choose QuickBooks Desktop Help.
  3. Click on Contact Us.
  4. Enter a keyword of your concern or simply type in the error message, then select Let's talk.
  5. Choose Get a call as a way to connect. 
  6. Enter your contact information, then hit Confirm my call.

 

You can also use this link to contact our support team if ever you'll have trouble accessing or navigating inside QuickBooks Desktop.

 

I've also added this links where you can find helpful articles that will make the navigating around QuickBooks even easier: QuickBooks Desktop Help Articles.

 

Click the reply button below for follow-up questions or clarifications. I'll be here to help. Keep safe!


Thanks so much I have contacted QuickBooks and they have had me try a trial version of 2021 to see if I can email reports in Excel format from there.  In the meantime, they are working on a solution.