Hi there @Jeanne1213,
Thanks for bringing this particular message to my attention. Here’s what I know about this error when running the Summarized Payroll Data in Excel report.
I received an update that there is currently an ongoing investigation regarding the message. We are still working to get it fixed as soon as possible.
In order for you to get the payroll details, you have to run the report from the previous quarters. Once you get a prompt to update, just click on Yes.
This workaround will pull up your data correctly.
I also suggest contacting us so we can add you to the list of affected users. This way we can notify you when the issue is resolved.
Here’s how to get in touch with our payroll specialists:
Let me know how the call goes. I’m here to help if you have other payroll concerns. Have a great day.
Update for Summarize payroll data in Excel -
I use an outside IT company. They installed an older version of MS 365 from November 2018 and shut off MS 365 auto updates. It worked! I have access to all my reports Excel reports now. I'm sorry to say that I do not know how they did this as I'm not computer savy.
I am also having this problem Started on Friday Jan 18th.
Thank you for coming to the Community for help, @NPFIUC.
I’m here to share some information about the error message you encountered.
As mentioned by my colleague, there’s currently an open investigation about the message when running the Summarized Payroll Data in Excel. Our engineers are working to get a permanent fix for this unexpected behavior.
You can run the report from previous quarters, as a workaround. When asked to update, select yes and it will pull up the data correctly.
In the meantime, please give our Customer Care Team a call to add your account to the list of affected users. This way, we’ll be able to notify you of any updates once received.
Here’s how to reach phone support:
1. Go to this link: https://payroll.intuit.com/support/contact/.
2. Select your payroll product.
3. Choose Payroll.
4. Click View Contact Info.
We thank you for your patience, @NPFIUC. Please let me know how the call goes. Leave a reply below if you need anything else. Take care!
We also reverted to Microsoft Office 365 version Nov 2018 and turned off auto-updates. Please let me know when you are in sync with Microsoft.
Thank you for getting back to us here in the Community, @NPFIUC.
I'd be glad to help you today.
As mentioned by my colleagues above, there's an ongoing issue/error when using Summarize Payroll Data in Excel. Our engineers are all hands on deck working together for an immediate fix.
To receive resolution updates, I recommend getting in touch with our Support Team and have you added to the list of affected users. For the support's contact information, you may refer to the steps provided above.
Don't hesitate to add a comment/post if you have any other QuickBooks concerns, it's my pleasure to help. Thank you for your patience!
Can you post back on this thread once the issue is resolved? My client is experiencing this issue as well. I resolved it by reverting her to a prior version of Office:
C:\Program Files\Common Files\microsoft shared\ClickToRun>officec2rclient.exe /update user updatetoversion=16.0.11001.20074
But this is not a long term solution as she will need Office security and other updates. Please post back to this thread when Quickbooks has resolved the issue on their side so we can turn Office updates back on.
Hey there, scotru.
Thanks for joining this thread and letting us know you’re one of the affected users.
This has already been reported as an ongoing issue with QuickBooks Desktop Payroll and our product developers are diligently working to fix this as soon as possible. While waiting for the permanent solution, I'd suggest contacting Payroll Team so they can add you to the notification list to receive email updates.
Rest assured that I’ll be updating the post once there’s a progress to the issue.
I appreciate your patience while we look into this. Reach to me direclty if you have questions while working in QuickBooks. I'll be right here for you.
We are still having the same problem and have been for a week. When is this going to be resolved? It is time consuming to get a SUTA worksheet without this.
Hello there, Jabrenda.
We're unable to provide a specific time frame to when this will be fixed. Rest assured, our engineering team is working diligently to get this fixed.
We have a workaround for you to try. Run the report from previous quarters, then if asked to update, choose Yes. It's able to pull all the data correctly. If it won't work, uninstall and reinstall QuickBooks using clean install. Before doing so, make sure to create a back up of your company file.
Though, some of our customers are able to summarize the payroll data in Excel by rolling back the Microsoft Office updates.
You can contact our technical support as well to add you to the list of affected users. You can check my colleagues' answers on how to get in touch with them.
Don't hesitate to get back to this thread if you have further questions.
I am having the same issue and want to add my name to the list. When I follow the link you provided and click on the version you recommend, I do not see a "Payroll Tab" nor anywhere under the Payroll list of helps, any place where it says "view contact" . Please advise? I believe I am having two issues; the first is an error that pops up saying "Microsoft Visual for Basic Applications - Error occurred during load". Once I work my way around that, I get an issue with "please turn on Macros" I've followed the required steps to do so MANY times and it STILL won't work. I'm at a loss and VERY frustrated. I am NOT a techy person. Is there a number I can call for tech help that will enable someone to do a remote check so they can see what I am dealing with EXACTLY? Thank you.
Thank you for the detailed information, @Dwight Lane Painting.
I appreciate your efforts in trying out the steps to resolve the issue and getting in contact with QuickBooks support. Let me direct you to someone from the right support team.
You can find our Payroll phone number through this link: https://community.intuit.com/articles/1763740.
After pulling up your account in a secure environment, they can do screen-sharing and help you resolve the errors in your QuickBooks Desktop.
However, if you have any general questions or concerns working with QuickBooks, you can post it here. Simply click the Reply button and I’ll do what I can to assist you.
In the meantime, let’s try uninstalling and reinstalling Microsoft to fix the issue. If you’re not comfortable doing the following steps, contact your computer’s manufacturer or Microsoft.
Here’s how to uninstall Microsoft Visual C++:
1. Close all open programs.
2. Press Windows+R on your keyboard to open the Run command.
3. Type in Control Panel and click OK.
4. Choose Uninstall a Program.
5. Select the version of Microsoft Visual C++ for your version of QuickBooks.
6. Click Uninstall and follow the onscreen instructions to uninstall the program.
7. Restart your computer.
To reinstall, download Microsoft Visual C++ from the website.
For more details, you may check out this article: Uninstall or reinstall Microsoft Visual C++.
That should do it. Please reach out to me if you have any questions, I’ll be here to help you out. Thanks for dropping by, I’ll keep an eye out for your response.
Why can QuickBooks not release a patch or something in an update that can correct this excel problem. I honestly do not feel comfortable uninstalling and reinstalling this Microsoft Visual C on my computer. It will cost our firm money if we contact the IT people to do so. QuickBooks needs to resolve this. We pay for a payroll subscription and part of that service has been hindered for more than a month now.
Thanks for joining this thread. Allow me to jump in and provide some update about the error when using Summarize Payroll Data in Excel feature in QuickBooks.
I've checked the investigation status about this issue and it's still in progress. Currently, we haven't received any updates if when this will be resolved but rest assured that our engineers are currently investigating and working on an immediate fix.
For the meantime, I encourage you to contact our QuickBooks Desktop Support Team so they can add you to our notification list of affected users to receive live email updates about this issue. Once you're with our phone specialists, please inform them to add you to the investigation number INV-24874.
Here's how you can contact our live support:
We appreciate your patience as we work through this. If there's anything else I can do for you, please let me know. I'll be around to help you out.
I have tried to run the report from the previous quarter. I get the same message. Can you include details on how you are doing this so that I can try it the way you are doing it? This is absolutely crazy that we have been dealing with this issue for so long AND that we pay for this service and it isn't working when we NEED IT!!!
Our engineering team is still investigating the cause of the error when generating the Summarize Payroll Data in Excel report.
You can try to uninstall and reinstall locally the MS Excel. Please note that Office 2019 is currently not supported in QuickBooks.
No worries. I'll keep in touch with this post once I receive an update from them.
Thanks for your patience while we look into this. Take care always.
We have been getting this same error message since JANUARY and it is now April!!! Today I got an email from your support team telling me that this issue will not be fixed anytime in the future. Are you kidding me? I am paying for this in my monthly service. This is not an acceptable solution.
Thanks for joining this thread, @Kathy31.
Let me help share update about the Summarize Payroll Data in Excel error in QuickBooks.
I understand it can get frustrating to have your issues at repeated occurrences. As much as I would love to provide if when will get this resolve, however, we still haven't received any updates yet.
Our engineers are continuing to work on solving for this unexpected behavior and rest assured that updates will be sent to you once this gets resolved.
I appreciate your patience. Please know that I'm just a post away if you have any other questions. Have a good one.
The sad thing about this it that it's been going on for months and QB still has not come up with a solution. Just saying...
As much I appreciate your response, it does absolutely nothing to help me with this issue. I am fed up with these auto-generated replies, which do not really address the problem. I am calling the billing department today and demanding a partial refund for my payroll subscription fee and I suggest everyone who is being affected by this never-solved problem, do the same.
Hello there, @Kathy31,
While our engineering team is still working on the resolution to fix the issue, we found a similar post from customers who were able to pull up the report.
Some customers have reported success with hitting "Yes" to the first error. This allows you to navigate and select the year and tax form you want to generate. Then, close the second error about the "Reports to "QB_Payroll_Link2". While some customers rolled back to the previous version of Office 365.
You can visit this page: https://quickbooks.intuit.com/community/Reports-and-accounting/error-107320/td-p/222474/page/2. Then, look for @casrookie and @BrandonT replies in the thread.
I appreciate your patience and looking forward on the results after trying the workaround.
If someone just needs an excel worksheet for their State Unemployment, the best way to get one now is to go to "Reports", "Employees & Payroll", "More Payroll Reports in Excel", "Tax Form Worksheets". Choose the button for State Wage Listing and the quarter you need. This will list State withholding too but you can hide it. You can also add a column to have the excess wages calculated. It takes just a little more time, but it gives the results you need for the State Unemployment reports. I hope this helps! Someone from QB just helped me do this. :)
I'm glad to hear this worked for you.
The information you posted will definitely help others that may have the same concern. However, allow me to provide the step-by-step process to this in QuickBooks.
You may find this article helpful: Excel-based payroll reports.
We also have resources available to help you grow and manage your business, all you need to do is visit the QuickBooks Resource Center for more information.
If you need more help in QuickBooks in the future, you can reach out to our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours.
The Community is always in your corner if you ever need assistance again in the future. Take care.
This is not a "fix" - I am not able to run any payroll reports in Excel, I keep getting the error message, and you just explained the step by stem of how to run payroll reports in Excel. How do I get around the error message???