cancel
Showing results for 
Search instead for 
Did you mean: 
Ianheegaard
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
Ianheegaard
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

4 Comments 4
Catherine_B
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!

Ianheegaard
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.

LisaC2023
Level 1

Cant export to excel

I am using QB Premier desktop and Microsoft 365. Since the last QB update, the options in reports to export to Excel are grayed out. How can I fix this?

GlinetteC
Moderator

Cant export to excel

I'm here to help you fix the grayed-out export options for Excel in reports, LisaC2023

 

You can start by verifying the system requirements for your QuickBooks version. Each edition of QuickBooks Desktop is designed to work with specific versions of Microsoft Office. If your current version of Excel isn't compatible with QuickBooks, you will need to upgrade to a supported one. 

 

If you have the appropriate version, you can repair your Office application to resolve the issue. Afterward, return to QuickBooks and attempt to export a report.

 

Another possible solution is to toggle your Windows UAC (User Account Control) settings on and off. This can help reset any obstacles preventing the export feature from functioning correctly.

 

Here are the steps to follow:

 

  1. Open the Windows Start menu.
  2. Type User Account Control Settings into the search bar and open the corresponding result.
  3. Move the slider to the Never Notify position.
  4. Click OK to save the changes.
  5. Restart your computer to apply the new settings.

 

If the problem continues, proceed to Step 5, mentioned in this article to resolve any issues you encounter while exporting to Excel: Fix export to Excel issues in QuickBooks Desktop.

 

You can explore these articles for more insights on managing reports in QuickBooks Desktop.

 

 

Please know that I'm always here to help if you have any other questions about exporting reports to Excel. Just add a comment below. Keep safe!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us