Thanks for getting back to the QuickBooks Community, dso0216.
Allow me to step in for a moment and help fix the error you're getting when exporting reports from QuickBooks Desktop (QBDT) to Excel.
Generally, the Excel cannot open the data file error message can be resolved by restarting the computer. Here's how:
If the issue persists, let's update your QuickBooks to the latest release. This will help you download the changes, improvements, and fixes that were made to QuickBooks. Here's how:
For additional reference, you can check this article: Update to the latest release of QuickBooks Desktop.
Next, let's run the verify and rebuild data in QuickBooks Desktop utility. This tool will fix any errors it can find and notify you of anything that needs to be manually corrected.
Once done, try to export your report again to Excel. If you're still getting the same results, you can repair QuickBooks Desktop to fix program-related issues or errors.
If you need further assistance with the steps, I recommend contacting our QuickBooks Desktop Support Team. They have the tools to pull up your account and do a remote session.
Here's how you can contact our technical support:
That should get you fixed right up! Please know that I'm just a post away if you have additional concerns about exporting report to excel. Have a good one.
I believe I got this one figured out today. Putting together my own experience and what I saw others post online what I believe it is is that Quickbooks simply doesn't work with 64-bit version of Excel.
What made me extremely frustrated is that I believe that Intuit knows about this bug but will not acknowledge it, nor will it authorize the phone support to tell the customers about it. I spent over an hour on the phone doing pointless repairs and updates when I believe the phone rep knew from the beginning what was going on but because of the company policy was not allowed to directly tell me. After spending all that time on the phone and reading different online posts about the same problem I was able to figure out what to do from what she was not telling me. Basically I just had to uninstall 64-bit version of Office and install 32-bit version, that's all, no updates or repairs necessary, it works with 32-bit version and doesn't work with 64-bit version, that's all there is to it.
Intuit/community admins please understand that I am not trying to put down the phone representative who diligently and to the best of her ability honestly tried to help. What I am saying that while my overall long-term experience with Quickbooks has been very much a positive one and while generally I had very good experience when I needed tech support this is an example of poor customer service. If you can't fix a bug at least put up some kind of notice about it and don't waste our time!
I want to thank you for taking the time to share the solution on exporting a report to Excel. This will surely help others who might have the same issue.
I may haven't personally experienced what you've gone through, but know that you have the right to be heard and I'm here listening to you.
Rest assured I'll pass along your feedback here on my end. Please let me know if there's anything else you need, I'll do my best to help you out.
You might find the system requirements of QuickBooks Desktop helpful for the version of your QuickBooks account. I recommend checking out these articles to ensure your computer meets the requirements:
Thanks for your patience. Take care always.
Hello there, dso0216.
Allow me to provide additional troubleshooting option that can help you export report to excel successfully.
If you've recently update your Excel version, you can revert the update. If you're not sure on how to this, I recommend seeking help from your IT professional or get in touch with Microsoft technical support. They can help you in reverting Excel updates.
If doing this doesn't work, I recommend contacting QuickBooks Customer Care so they can take a closer look and conduct a deeper investigation on what's causing the error.
Be sure to keep in touch with me here should you have any additional questions or concerns. I'm always here to help.
I tweaked instructions for another error and it worked for this one! Save and close any open Excel files. Use CTRL-ALT-DEL and select the Task Manager. Under the Processes tab, look for instances of Excel.exe and select End Process. This should allow you to export your file from QuickBooks to Excel without rebooting your computer or shutting down QuickBooks.
Hi there, @Cyborg.
Thanks for letting me know what troubleshooting step you've tried to export the report. Let's get this working to get you back on track.
First, let's check if the Excel you have is compatible with the version of QuickBooks you're using. I recommend checking the following article to see the software compatibility: QuickBooks Desktop system requirements.
Technically, restarting the computer can resolve unexpected behavior with exporting the report to Excel. Since you get the same result, can you confirm if you already tried the steps provided by DebraP? When the Excel cannot open the data file exported, closing the excel.exe can do the tricks.
If you're still receiving the issue, let's make sure you have an active and up-to-date version of QuickBooks. Then, try to repair QuickBooks and run a Detect and Repair for Microsoft Office to fix possible damaged files.
After that, restart your computer, then open QuickBooks. Please try to export the report again.
Give this a try and let me know how it goes. I want to make sure everything is working on your end. If you need further assistance working with QuickBooks, please leave a comment below. I'm always here to help. Wishing you the best!
Still no luck. Contacted PA support and spoke to a rep who first drilled me on why I needed to export files to excel?? Anyway, he tried to help but was unsuccessful. The client contacted their IT guy who discussed the issue with me. He told me he worked on the same issue with another client for 3 hours the other day. The end result was they couldn't fix the issue. Intuit told them they needed to go to QBO so that's what they did. That's not happening in this case and I think the client has had enough since they don't export reports to excel, I do that. The work around is using another employee's workstation. The workstation I use when I'm there hosts the file and she accesses as a second user. Interestingly enough her on her Windows machine QB export to excel works fine. So I'm stumped as to what to do from here.
Thanks for joining this thread, dso0216.
I appreciate letting us know that you’ve already contacted our Technical Support about the issue and its result.
Since your client can export the report using another computer, we’ll have to check how the Excel is installed on the device. The way the software is lodge also affects how it works.
I suggest reaching out to our Technical Support again since they have tools to configure the software’s setup. For your convenience, you can either choose to chat with a support agent or arrange a callback.
With our support team's help, you should be able to export Excel to all computers.
Please let me know how it goes after contacting them. I want to make sure this is taken care of.
Infact I am getting this issue as well when I export report. It says "We found problem with some of contents of the file. DO you want to recover as much possible and it goes on repair mode. Though Excel's Automatic feature repairs it. I was wondering why this happens and is there any way to solve this.
Tell, if you found out something that helps.
Hello there, @kajalkhatri.
Let's update your QuickBooks to its latest release. This will help you download the changes, improvements, and fixed that were made in QuickBooks.
Next, let's run the verify and rebuild data in QuickBooks Desktop utility. To fix any errors it can find and notify you of anything that needs to be manually corrected.
To run the Verify and Rebuild utility, here's how:
Once done, try to export your report again to Excel. If the issue persists, you can repair QuickBooks Desktop to fix program-related issues or errors.
Feel free to reach out to us if there's anything else you need help with QuickBooks.
Thanks for responding, kajalkhatri.
I have more steps we can try to fix errors when exporting reports to Excel. Let me share them with you so you can get started.
To begin with our troubleshooting steps, let's uninstall and reinstall Excel. This way, we can identify if it has something to do with your Excel program or not.
Once you're done, open your QBO account and export your report again.
If you're getting the same result, please contact our Customer Care Support so we can further investigate and create a case for you.
In the meantime, you can use a different program like Google Sheets to open your workbook.
I've also got this article about memorizing reports in case you need some.
Please let me know in the comment section below if you have other questions. I'd be glad to help. Enjoy the rest of the day.
I actually tried this export thing of same report on 2 different desktops and results were same. So, I don't think so its something to do Excel on my system. I think I will have to jump to second step to contact customer care.
Hi there, @bajake.
I appreciate you for performing the steps above to help fix this issue. Since none of these works for you, I recommend contacting our Customer Care Team. They can run a remote-viewing session to investigate the root cause of this matter and provide a resolution.
To reach them:
To guide you in exporting reports in QuickBooks in the future, please see this link: Export reports as Excel workbooks in QuickBooks Desktop
If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.
Hi there, Raeann1965s.
I appreciate you for performing some steps to resolve the issue. Since you're still unable to export reports, I suggest contacting our QuickBooks Support Team. They have the tools to figure out the cause of this problem.
To see a visual reference on how to contact support, you can follow the steps given by colleague BettyJaneB.
Please check this article on how to customize the data, add or delete columns, and even personalize the font and style of different reports in QBDT: Customize reports in QuickBooks Desktop.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
Download an older version of Excel, I put Office 2007 on my computer and have not had any problems ,since.. you could probably use Office 2016 .I believe Microsoft 365 causes great problems with the exporting part of QB