Link to home
Start Free TrialLog in
Avatar of Jerry Redmon
Jerry RedmonFlag for United States of America

asked on

Quickbooks 2015 Enterprise exporting reports very slowly to Excel 2013 or 2016

We have a problem where Quickbooks users have to export reports to Excel.   When the user's were using Excel 2010, there was no problem exporting.  For example, when they used Excel 2010 one particular report took only about 1 minute to export to Excel 2010.  After "upgrading" to Office 2013 and then to 2016 (to try to fix problem), the same report may take about 10 minutes to export to Excel.   I've followed various forums and even a solution on Experts Exchange, but, none of them have any resolution that's worked for us.  

After trying various thing from QB's website and the usual  tasks like: Windows updates, defrag, QB database rebuild, and chkdsk, I uninstalled 2016 on one system and reinstalled Office 2010 and this fixed the issue.  Even after installing 2016 alongside 2010 and making Excel 2010 the default spreadsheet application, everything is working great like it used to.   However, we have 3 new users and we're faced with either purchasing standalone Office 2010's for them or trudging along using our Office 2016.

It seems like a lot of people online have had the same problem but don't see many solutions to this issue.  Has any found a vaild solution to this?
Avatar of John
John
Flag of Canada image

I am using QuickBooks V2017 with Office 2016 and do not have any undue slowness. Big reports of course take more time.

Consider upgrading QB to match the new software you are using.
Avatar of Jerry Redmon

ASKER

John,
Are you using QuickBooks V2017 Enterprise version?
ASKER CERTIFIED SOLUTION
Avatar of John
John
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is upgrading to QB V2017 the only solution?
I keep QB up to date myself and at clients. I cannot say with certainty it will solve your issue but I do not have / my clients do not have this issue except for huge reports which is normal.
My understanding from the user is that any size export will cause the problem.  However, I'm contacting them to find out what the worst case scenario is.   Once again, on one system which we've defaulted MS Office to 2010, the reports export very quickly.
60kb is the largest exported file size, so, that seems to be really small
That is small. I did a bunch of these (3 or 4) twice in the last 10 days. Very fast (well under 1 minute) .

QB V2017 Premier running on Windows 10 Pro 64-bit
We're going to update to QB2017 next week and I'll see if that solves problem.
We upgraded QB to V2017 and resolved issue.
Thanks for the update and I was happy to help.