3,920 questions
QuickBooks lol
Excel slow working with QuickBokks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 94%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LVS
1
Reputation point
When QuickBooks is pushing data to Excel it is unusably slow. This happened after Office updated, it takes a good 25 minutes to populate say the prevailing wage report. On machines that have new or installs of Office before Quickbooks installed it takes about 3 minutes. Only happens after Office updates. I have uninstalled office, reinstalled to no avail.
Thanks
Microsoft 365 and Office | Excel | For business | Windows
4 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 92%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECQ%3C/text%3E%3C/svg%3E)
Charles Qi_MSFT 976 Reputation points2022-12-06T06:44:59.73+00:00 Hi, @LVS
You can have a try of rolling back Office to the previous version and see if this problem can be solved.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in email-notifications to enable e-mail notifications if you want to receive the related email notification for this thread. -
LVS 1 Reputation point
2022-12-06T18:39:19.233+00:00 I have tried to roll it back unsuccessfully using
cd %programfiles%\Common Files\Microsoft Shared\ClickToRunofficec2rclient.exe /update user updatetoversion=16.0.149231.208206.
On My machine I updated Office and it slowed down. I reinstalled Quickbooks and it was almost as fast as i was when I started. Tried it on the other slow machines, it did nothing to help.
-
Emily Hua-MSFT 27,796 Reputation points2022-12-13T09:24:38.31+00:00 Hi @LVS
On Microsoft Answers Community, I found you have resolved this issue.To help others on Q&A who encounter with same issue, I would copy the link your reply. Thanks for your understandings.
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-is-painfully-slow-like-10-minutes-when/f1360645-2ffd-4867-9b04-abc9253124e5?page=2#:~:text=We%20have%20figured%20it%20out%2C%20%20all%20macros%20must%20be%20enabled%2C%20%22ya%20I%20know%20not%20good%22%20and%20the%20COM%20add%20in%20swift%20excel%20has%20to%20disabled.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
gotomyerp Services 1 Reputation point2022-12-20T22:14:51.607+00:00 Hi LVS-9628,
We're a specialist in just about everything QuickBooks Hosting. We've seen this issue with QuickBooks before and have extensive documentation for this and other issues on our site that might be able to help you. Please consider.
TITLE OF OUR KB:
QuickBooks reports are slow when exporting to Excel worksheetProblem:
When exporting a QuickBooks report to Excel, the export process is very slow.Resolution:
- While in QuickBooks, perform the following:
- Open your QuickBooks company file
- Run a report to export to Excel
- Select Excel > Create New Worksheet
- Click Advanced in the "Send Report to Excel" window.
- Deselect the Freeze panes checkbox
- Click OK
- Click Export
The export process should now be much faster.
We hope you found this useful.TAGS:
QuickBooks Enterprise by gotomyerp
QuickBooks Enterprise Hosting by gotomyerpFrom Our https://gotomyerp.com/quickbooks-hosting
KB: quickbooks-reports-are-slow-when-exporting-to-excel-worksheet