cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
PattiB2021
Level 2

Emailing Reports on QB 2019 In Excel Format

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 Comments 6
AileneA
Moderator

Emailing Reports on QB 2019 In Excel Format

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!

PattiB2021
Level 2

Emailing Reports on QB 2019 In Excel Format

Thanks so much Aileen,

Unfortunately, none of the fixes have worked. I went though each potential fix one by one.

 

I have uninstalled and re-installed Office, twice now. I have done all updates and rebuild files and fix files.

 

I have been through the articles and tried everything they suggest.  I am still getting the same message.  If you run across anything else that could help, I appreciate you letting me know.

 

Patti B

PattiB2021
Level 2

Emailing Reports on QB 2019 In Excel Format

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!

Archie_B
QuickBooks Team

Emailing Reports on QB 2019 In Excel Format

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!

PattiB2021
Level 2

Emailing Reports on QB 2019 In Excel Format

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.

PattiB2021
Level 2

Emailing Reports on QB 2019 In Excel Format

Just a quick update to let you know that the trial version of QB 2021 Desktop did not fix the Excel/email issue, as the QB tech support had hoped.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us