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
THIS WAS ALREADY DONE AND THEREFORE HAD NO EFFECT
AND THIS Option C:
Under Ease of Access, Turned off all unnecessary animations (when possible).
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
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.