Excel & QB crashes when I export reports.When it does work, it creates a blank Excel page. Windows 10, Office 2016 and QB pro 2016,how do you get them to work together?

chickiebarnes80 · ‎December 10, 2018

Excel crashes each time I export reports out of QB. Only been doing this since Windows 10 roll out. I can't roll back my version, as I this is a new laptop, and it's the only version that came with it. Been quite frustrating having excel AND Quick-books crash when exporting to Excel. The worst part is when it does work, it creates this blank Excel page (no grid or worksheet, just a grey background), and if I close it, it closes the ENTIRE program of Excel and all of my open workbooks.. there is no options to keep one workbook open over another, the entire program closes. Im sorry, but that sounds alot like it's not compatible with Windows 10 or Excel 2016, can't quite tell which one is the problem child at this point. If I use my old desktop computer with Windows 7, it works with out ever crashing, or having issues with Excel. I have Windows 10, Office 2016 and Quickbooks pro 2016. Any help would be much appreciated.

ShiellaGraceA · ‎December 10, 2018

Hi there chickiebarnes80,

Thanks for posting.

Microsoft Office/Excel 2016 is compatible with QuickBooks 2016 R7, except for exporting reports. Exporting reports requires Microsoft Excel 2013, 2010, or 2007.

You can refer to this article to learn more about System requirements for QuickBooks 2016.

Let us know if you need anything else.

View solution in original post

ShiellaGraceA · ‎December 10, 2018

Hi there chickiebarnes80,

Thanks for posting.

Microsoft Office/Excel 2016 is compatible with QuickBooks 2016 R7, except for exporting reports. Exporting reports requires Microsoft Excel 2013, 2010, or 2007.

You can refer to this article to learn more about System requirements for QuickBooks 2016.

Let us know if you need anything else.

chickiebarnes80 · ‎December 10, 2018

This is very disappointing. Any updates in the near future to fix this? This is a huge issue, that effects my everyday tasks in Quickbooks. I do not know what to do with your answer but take it as: "your shit out of luck", as my new computer came with these specs. I only have Office 2016. I think it's ridiculous you expect people to repurchase an older version of office to work with your program. You are the leading Accounting program out there, and you can't get reports to work with the new versions of Office?

lforbis · ‎December 10, 2018

I agree 100%!!!! Come on Intuit, get with the times and last years technology. Reports and Excel go hand in hand for everyone who uses your software! We cannot function if you can't keep up with MS.

jsparso · ‎December 10, 2018

This is slowing me down incredibly. I have to upgrade to 2016 so I could still use enhanced payroll yet I lose functionality with one of my most repeated tasks. Please fix this......

tntharris · ‎December 10, 2018

I have Office 2010 and there are still crashes when I export reports...the warning box pops up and says QB 2016 and Office 2010 are not compatible!!! So frustrationg!

ShiellaGraceA · ‎December 10, 2018

Hi @tntharris,

Were your Office 2010 installed locally? Office 2010 and Office 2013/365 (including Outlook 2010 and Outlook 2013) both on 32 and 64 bit are compatible with QuickBooks 2016 only when it is locally installed, not the web version. You can try renaming the XMLLITE.DLL file from the QuickBooks program directory. Here's the detailed instruction:

<a rel="nofollow" target="_blank" href="http://support.quickbooks.intuit.com/support/articles/SLN96445">http://support.quickbooks.intuit.com...>

Let me know how it goes, and we'll take it from there. Thanks!

sue11 · ‎December 10, 2018

When will this be fixed??

shelleyparnes · ‎December 10, 2018

My computer died and I had to install Office 2016. I am a CPA and I export a lot of reports each month when I prepare financials for my clients. So, this Excel export issue is a real problem. Has this been fixed yet? If not, is there a way I can be notified when it is fixed? Thank you!

wizable-us-c · ‎December 10, 2018

This is crazy, I am just finding this out. I have QB Pro 2015, and would upgrade to anything that is compatible with excel 2016 to be able to export - anyone know of a fix?

czulian · ‎December 10, 2018

Any progress. We have MS 2016 and other clients are using 365. Microsoft is progresses what is the problem with intuit?
This is a severe issue that intuit cannot give a flying leap about. If importing data with the stupid IIF files wasn't bad enough, exporting to Excel is a critical component of using QB. Who would buy a car if you couldn't get what you put in the trunk out? The lack of progress over several years must mean QB is abandoning desktop for the online version? Now if the online version was better or even close to the desktop version, I might switch. We certainly are looking at alternatives.

MVEBA · ‎December 10, 2018

So should work QB 2015 Pro to Excel 2013?

Toni USD 380281 · ‎December 10, 2018

@IntuitShiella the link you provide has moved, this happens so often when I find an answer that will resolve my issue. At least 10 times this evening.

ShiellaGraceA · ‎December 10, 2018

Hi @Toni-Marie,

Try updating your QuickBooks release version by following this link:
<a rel="nofollow" target="_blank" href="https://community.intuit.com/articles/1501562-update-quickbooks-desktop-to-the-latest-release">https...>

This fixes issues that caused QuickBooks crashed while exporting reports to Excel.

Hey @MVEBA,

Excel 2013 is QuickBooks Pro 2015 compatible. You might want to check in this article:

<a rel="nofollow" target="_blank" href="https://community.intuit.com/articles/1502336-system-requirements-for-quickbooks-2015-and-enterprise...>

Thanks!

tregidkaren · ‎December 10, 2018

I just want to say after reading these comments re: Excel 2016 and QB 2017 not being compatible...it STILL HAS NOT BEEN FIXED. VERY frustrating!! I did discover that if you want to go the extra expense of buying separate programs from Microsoft instead of their less expensive "packages", you can choose NOT to purchase the current Excel. This really isn't acceptable. I prefer the updated version of Excel over the older 2007 (that QuickBooks works with). So, until Intuit can get up with the times I have to unload and reload my Microsoft 365 package when I want to run specific Excel reports from QuickBooks (which is every 2 weeks for now). ALL my documents are on the updated format of Microsoft; you should see what the older version does to the formatting. I have to reload 365 to have my other files work properly. This is an INTUIT issue not Microsoft.

czulian · ‎December 10, 2018

We have moved to exporting CSV format for the many, many, many exports we doe for our reporting. It is more cumbersome and doe snot export the date and time of the reports, but it works.
Still this is a very blatant disregard of the loyal customers, myself since VERSION 1.

amberanderson · ‎February 03, 2020

Wow, I am currently in the year 2020 and this has still not been resolved?? Have QuickBooks engineers continuously worked on this for years to no avail or have they just decided it's best to no longer keep up with the times? Please let me know if that is the case so I can make the move toward another accounting solution.

AlexV · ‎February 03, 2020

Chiming in to share details of the QuickBooks Desktop software compatibility, amberanderson.

The Microsoft Excel 2016, 2013, or 2010 SP2 or Office 365 are supported in QuickBooks Desktop 2020. If you're using any of these, rest assured that you can export your reports smoothly.

You can also read this guide to learn more: System requirements for QuickBooks 2020 and Enterprise Solutions 20.0.

In addition, these articles will give you the list of data you can export:

Please comment again if you have more clarifications. I'll be glad to help.

amberanderson · ‎February 04, 2020

Hey AlexV,

Thanks for your response but unfortunately that is not the case. I've had trouble with my reports for several months now and I've been told by your company that they are 'still working' on the issue and I have been 'added to the current case' and they will contact me 'as soon as they find a fix' but that has yet to happen. This is an issue with my scheduled reports as well. I am running Windows 10 with Microsoft 365 and Quickbooks Enterprise 20. Apparently the three are not compatible so I just wait..........

MarsStephanieL · ‎February 04, 2020

Hi there, @amberanderson.

This issue about the compatibilities of Windows 10 with Microsoft 365 and QuickBooks Enterprise 20 has already been acknowledged by our product engineers. They are working diligently to fix this.

You will be notified whenever they come up with a fix through e-mail.

As of the moment, you can export your reports by using the Microsoft Excel 2016, 2013, or 2010 SP2 or Office 365 because they are supported in QuickBooks Desktop 2020.

We appreciate your patience in this matter. Feel free to let us know here if you have questions in mind. I’ll get back to help you out. Take care.

Moses4997 · ‎April 02, 2020

@MarsStephanieLWhat is the status of this? I have several Quickbooks 2020 servers out there having this issue with Office 2016, Office 2019, and Office 365 click to run versions. What is the FIX???!!! This is a huge deal and cannot find a viable solution. Please don't just say that the are compatible. While that may be, this particular work flow of exporting to Excel from within Quickbooks is broke broke broken and completely locks up the session. Any assistance would be greatly appreciated. Thanks!

ChristieAnn · ‎April 02, 2020

Hi there, Moses4997.

The issue with Office 2016, Office 2019, and Office 365 has been reported as resolved. Since you still encountered an issue in the flow of exporting to Excel from within Quickbooks, I suggest making sure your version of QuickBooks is up-to-date.

If it's already updated and the problem persists, you'll need to check the system requirements for your version of QuickBooks: 2017, 2018, 2019, 2020. If your version of Microsoft Office isn't compatible, you'll have to upgrade this office. If it's compatible, follow the steps from Microsoft to repair Microsoft Office. And, then go back into QuickBooks and start exporting.

If the steps above didn't work, you can refer to this article and start following step four: Fix export to Excel issues in QuickBooks Desktop. This contains additional troubleshooting to fix the issue.

I suggest contacting our QuickBooks Support Team if the problem continues to occur. They have the tools to pull your account and investigate the cause of the issue.

Press F1 to open the Help window.
From the search icon, type Contact Support.
Click Contact us at the bottom part.
Give a brief description of your issue about exporting and click the Search button.
You'll be routed with How to connect with a QuickBooks expert and you choose which one is best for you.

Ask the Community – allows you to post your question broadly so that a variety of experts can answer.
Message an Agent – Allows you to chat directly with a support agent.
Talk to a Specialist – Arranges a callback from a support agent.

Please check this article to see the new features offers in using QuickBooks Desktop Pro and Premier 2020 and Enterprise 20.0: What’s new in QuickBooks Desktop 2020.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

Topics

Training

Community

Resources

Excel & QB crashes when I export reports.When it does work, it creates a blank Excel page. Windows 10, Office 2016 and QB pro 2016,how do you get them to work together?