Quickbooks 2014 slow export to Excel 2013

Elixir2
Elixir2 used Ask the Experts™
on
This problem is all over the internet, but I'm hoping someone here will be able to push me in the right direction. The problem reported is one which I can duplicate. I am running on a 1-year-old server with Xeon E3 processor and 20GB RAM with a 3TB raid. It is running Server 2012r2 and Office 2013 Pro, both fully updated.

We have 5 concurrent users who all connect through RDP in the office to work on the server. The server CPU load is around 10% and RAM use is around 20% for all users during the peak of business hours. I can duplicate the issue by creating a new dummy (empty) QuickBooks 2014 Company file. I choose any of the default reports, for example, Open Invoices. I choose the Export to Excel feature at the top of the report window. And it just crawls...

Here is a quote from someone else who experiences the same issue:
"I don't see how the order of installation would make a difference and it appears it didn't solve the problem.  I am having the same problem, where it fills in the cells individually as if someone is typing it out quickly.  And if I dare even CLICK on the sheet or another Excel sheet while it's filling, it will skip entering data in cells where there should be data."

I TRIED THIS > Option A: When copying report to Microsoft Excel under the Microsoft Excel options, uncheck Use freeze panes and under Report header option, check Show header in Microsoft Excel worksheet. THIS HAD ONLY MINIMAL EFFECT, BUT DID NOT SOLVE THE ISSUE.

AND THIS > Option B:
1. Open Microsoft Office Excel 2013
2. Select File, then Options
3. Left-click Advanced and scroll down under Display
4. Check Disable hardware graphics acceleration  
5. Select OK
Cause: New enhancement in Microsoft Office 2013 called GPU rendering
From <https://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/148/t/76239#pi11061=3
THIS WAS ALREADY DONE AND THEREFORE HAD NO EFFECT

AND THIS Option C:
Under Ease of Access, Turned off all unnecessary animations (when possible).
From <http://winsupersite.com/article/office-2013-beta2/office-2013-tip-disable-animations-143779
And turned off most of the automation in Excel (spell checking, etc.)
AGAIN, THIS WAS ALREADY DONE, SO NO EFFECT.

I ALSO TRIED
to back up the file then use the main menu File>Utilities>Rebuild and Verify run it as many times as necessary (but at least 3 times) until it completes, then close QB and re-open it and see if it helped
From <https://community.intuit.com/questions/676350-opens-minimized
BUT SINCE THIS ISSUE DUPLICATED WITH A BRAND-NEW DUMMY COMPANY FILE, THIS POINT IS MOOT.

So finally, I believe but have not really truly confimed this, that after I reboot the server, the problem goes away for a random time. What is a better solution?

I have the OK from mgmt to go backward (!) and reduce Office 2013 to Office 2010 because some of the research above seems to indicate this is an Office 2013 "animation" issue which did not exist as a problem in 2010 version.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Where is the QuickBooks data file relative to the user? Is the user connected to the QB database over a very fast network? Or over a remote network?

I have used QB from way back and Excel from way back and for a small database (you said new empty database) it is very fast. I am using QB V2016 now because of Payroll and Excel V2016 and it all works well together.
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Just to follow up, I am preparing ledgers for 2 companies for accountants. Exporting a General Ledger for 1 year in a large QuickBooks 2016 company file took about 3 minutes. This is normal going back through about 5 years of QB and Excel for the same company files. They just keep getting bigger.

Author

Commented:
Just to clarify some questions for John Hurst:

The QuickBooks company files reside on the server share drive. The users connect to the SAME server using RDP. Excel and QuickBooks are also installed on the server. So the answer to your first question is: QuickBooks files are on the same computer the user is working on. So a network is not even involved other than to provide an RDP connection!

EU gets cranky when the export takes longer than 60 seconds. Telling EU "that's the way it is" is not an option because this problem only exhibits itself randomly (stating this again). A "normal" export should only take around 15 seconds in this environment. This path of reasoning would lead us back to removing Office 2013 in favor of the faster 2010.
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Author

Commented:
My own research has pushed me to look at Fair Share CPU Scheduling on the server:
http://windowsitpro.com/virtualization/q-how-can-i-tune-fair-share-cpu-scheduling
I disabled Fair Share CPU Scheduling and will report back to see if this helps at all.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Try Office 2010 to see. QB will tell you if the export will be longer than 60 seconds. It should not be if there is a tiny file. It should be for me with very large general ledgers.

What is your real life time in a working general ledger to export a Trial Balance. Even for a large company file this should be under 30 seconds.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Have you tried Office 2010?  I have exported a number of files since this thread using QB V2016 (needed for payroll) and Excel 2016 and no issues at all.

Author

Commented:
We may try v2016. The problem seems to be intermittent, meaning the end user only complains about it once in a while. I have not tried 2010.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
I pound away on QuickBooks V2016 (need up to date for payroll) and Office 2010 (other worker) and Office 2016 (my machine) and exporting to Excel is always normal. Large exports take time, of course, but small exports are quick.
I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I have explained in several answers here that large exports take time.  "EU gets cranky when the export takes longer than 60 seconds". End user's expectations are unrealistic.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial