cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Cant export to excel

Hello ,

 

I am having the same issue as others with excel. I am unable to export a report , it is grayed out.

 

I have followed all steps suggest in other forums but am looking for more clarification.

 

the user has multiple QB yea ya installed and some have not been updated.

In previous forums and update of QB is suggested as a fix, does this mean that in order to export from say 2019 I must be fully upgraded across all installations?

 

secondly are there any other suggestions then those posted on the common forums for this issue. I have repaired , installed and uninstalled both QB and office ( 2013) , upgraded both , and deleted old registry keys. 

Let me know if anyone has found any other fixes.

 

thanks.

Solved
Best answer August 21, 2020

Best Answers
Highlighted
Level 1

Cant export to excel

After performing all standard troubleshooting techniques we found a solution. 

 

With office 2013 installed and quick books 2019 , we then installed office 365 on top of this.

after this 365 install quick books recognized excel 2013 and defaulted to export with this.

we then had to repair 2013 to get .xlsx file to default to 2013 as well.

No idea what caused this , I was told the install of 365 could be forcing a different version of .net framework to be used.

 

Hope this helps someone else , good luck.

View solution in original post

2 Comments
Highlighted
QuickBooks Team

Cant export to excel

Thanks for checking in with us, Ianheegaard.

 

I want to make sure you'll be able to export reports into Excel. It’s good you’ve performed the suggested troubleshooting steps to resolve the issue.

 

You don't have to upgrade QuickBooks Desktop and the Microsoft Office 2013 since we still support those versions. You'll just have to update QuickBooks Desktop to keep your software up-to-date so you always have the latest features and fixes.

 

Let me show you how:

 

  1. Go to the Help menu and select QuickBooks Desktop Help.
  2. From the Update Now tab, click Get Updates to start downloading. 
  3. Once completed, click Close and then close QuickBooks Desktop.
  4. When prompted, accept the option to install the new release.

 After that, let's toggle the Windows User Account Controls to reset anything that blocks the export feature. You can follow Step 4 in this article on how to fix export to Excel issues in QuickBooks Desktop.

 

If you get the same thing, you can get in touch with our Phone Support Team so they can immediately address your concern. You can also get in touch with us during these hours.

 

Please don't hesitate to mention me in your reply if there's anything else that you need help with. You take care and stay safe always!

Highlighted
Level 1

Cant export to excel

After performing all standard troubleshooting techniques we found a solution. 

 

With office 2013 installed and quick books 2019 , we then installed office 365 on top of this.

after this 365 install quick books recognized excel 2013 and defaulted to export with this.

we then had to repair 2013 to get .xlsx file to default to 2013 as well.

No idea what caused this , I was told the install of 365 could be forcing a different version of .net framework to be used.

 

Hope this helps someone else , good luck.

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us