Question

Does anyone have issues with a QB Enterprise reports exporting to excel

Forum|Forum|1 year ago
October 9, 2024
8 replies
127 views

Why did QB's Enterprise all of a sudden stop export reports to excel?? I count on that feature quite often, now I can only do a comma separated value file (csv) and that is a pain to convert and move around items as I need. Will this issue ever be fixed?

QuickBooks Enterprise Suite

C

ChristineJoieR

QuickBooks Team

Thanks for visiting us here today, Cwelch61. Let’s resolve this exporting report concern within QuickBooks Desktop. Rest assured, we’re here to support you every step of the way and ensure to give a resolution to your issue.

First, let's update your company file to the latest release to enhance the performance and efficiency of your software. This update will provide you with the latest features, security improvements, and bug fixes that can optimize your experience with QuickBooks.

Here's how:

Go to Help and select Update QuickBooks Desktop.
Select Update Now, then Get Updates.
Close and reopen your account to install the update again.

After that, we can verify whether you meet the system requirements for optimal performance. This will ensure that your setup is compatible and functioning as intended.

If your Microsoft Office version is current and you're still facing issues, you can move on to the next steps outlined in the Step 3-6 section: Fix export to Excel problems in QuickBooks Desktop: Fix export to Excel issues in QuickBooks Desktop.

I'm including this page in case you experience any issues with your company file. It provides detailed instructions and troubleshooting steps to help you resolve issues with your company file: Can't open your company file in QuickBooks Desktop.

Share your questions you may have about exporting data in QuickBooks Desktop. We're here to help you. Keep yourself safe.

C

cwelch61Author

The comment made to update my Microsoft Office is not the solution as my IT company updates every night. This feature stopped working a few UPDATES ago. One update and it just stopped working. I really think this is not a Microsoft issue. And I wish it would work again because I really used this feature alot. I feel this is an issue with QB's because after one of the updates, can't remember which, that feature stopped working. I think there needs to be a fix in QB's, not Microsoft.

C

cstocker

Mine won't even convert it to xls file, it creates a "comma separated value, csv" file. Then I have to go in a manipulate it. It just won't work and I CANNOT get QB's to understand and they can't figure it out.

Will your QB's export a smaller file to excel without it being a .csv file?? I don't understand why QB's can't figure this issue out and fix it.

We are able to pull "some" xls files but the larger reports HAVE to be csv or they crash while trying to export to Excel. Unfortunately in today's case I can't even pull the company GL for the year as CSV because it's over 32,769 rows which Intuit states is their "new limit" for excel. When I asked why Intuit had lower limits than Microsoft Excel's limits, they replied that it was to make the reports smaller and "more manageable". This has not made the reports more manageable. For the end user (us) we are forced to jump through all kinds of hoops to pull smaller periods, then spend countless hours trying to combine all the data including the sub-totals and totals where applicable. This issue began a few "updates" ago and after countless hours with our IT and Intuit, there seems to be no resolution. If someone wants their reports to be smaller, they should have the option within the system to do that...but Intuit should revert their program back to what it was before; meaning the Excel limits came from Microsoft, not Intuit. We are looking into 3rd party apps that may help us circumvent this issue, but honestly it's a shame that Intuit made this decision on behalf of all their consumers.

Sign up

Login with SSO

Let's get you signed in

Login with SSO