Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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:
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!
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.
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?
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here