Jerry Redmon
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?
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?
ASKER
John,
Are you using QuickBooks V2017 Enterprise version?
Are you using QuickBooks V2017 Enterprise version?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.
ASKER
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
QB V2017 Premier running on Windows 10 Pro 64-bit
ASKER
We're going to update to QB2017 next week and I'll see if that solves problem.
ASKER
We upgraded QB to V2017 and resolved issue.
Thanks for the update and I was happy to help.
Consider upgrading QB to match the new software you are using.