Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello QuickBooks,
I need some help .. I have user who is trying to export from quickbooks to excel and most of the options are grayed out .. only Comma is the option ..
I have installed all the quickbooks updates , and did a repair of office and still nothing ..
Any thoughts ?
Let's figure out the cause of the grayed-out and fix it to keep you going with your task, StarTrek133.
Microsoft Excel should be installed on the computer, and if you are using Microsoft Office 365, be sure you are using the version that is installed on your computer, not the browser version.
Then, make sure your QuickBooks version is up to date and that it meets the system requirements. Each QuickBooks Desktop version is compatible with particular versions of Microsoft Office. Check the system requirements for your QuickBooks version (2021, 2022, 2023). You can also follow Microsoft's instructions to fix Microsoft Office.
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.
I'll be right here to help if you have any other questions about exporting reports in QuickBooks. Just add a comment below. Have a good one!
Hey JoesemM,
Not sure if you read the whole post .. but all the things you suggested I have already done ...
Also it works fine in 2021 , but not in 2022 or 2023 ...
Thank you for getting back to us, @StarTrek133.
Since you're still having an error after trying the steps suggested by my colleague above, I suggest reaching out to our Customer Support team. They have the tools to check your account in a safe and secure environment, isolate the errors you're having, and help you resolve them.
Follow the steps below on how to reach them:
You can check this article for more information about the different types of support we offer and their availability: Contact QuickBooks Desktop support.
Here's also an article that provides detailed instructions on how to import and export MS Excel files in QuickBooks Desktop. It covers various scenarios, including importing data such as customers, vendors, items, and charts of accounts, and exporting lists, transactions, and reports into Excel: Import or export MS Excel files.
Let me know if you need more help exporting your report into an Excel file. I'm always here to assist. Have a great rest of the day!
You have QB Desktop Accountant 2022 and 2023, correct?
Install the trial version of QB Desktop Enterprise 2022 or 2023 to isolate the problem.
Hello 4Gal,
That is something that cant be done in this case .. the user loges into a RDS server with other people that is why there are multiple versions of quick books installed ..
Thanks Mjoy_D,
I am not sure about calling in as this is a production server and is in use by multiple people daily .. so making changes can be difficult ...
Also The link for importing excel files is what the user is doing , did you not see the screen shots that were posted ..
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.