cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Summarize Payroll Data in Excel issue

When trying to run Summarize Payroll Data in Excel as soon as we click the report we get an Excel message that reads "We found a problem with some content on QB_Payroll_Link.xlt. Do you want us to recover as much as we can?" If we say no the report does not run. If we say yes it runs but some of the tabs do not have complete information in them - especially the State Wages Listing tab. Worked with support and tried updating & reinstalling but no luck yet. Any other suggestions?

19 REPLIES
QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hi there, @casrookie.

 

Thank you for providing some details about the steps you've tried. I can help you resolve your report's Export to Excel issue.

 

You can try reinstalling using a super clean install. This is the last resort for issues that can't be resolved by a standard clean install. For important reminders and detailed instructions, you can refer to the article below.

 

Reinstall using a Super Clean install

 

After using the super clean tool, I'm sure that you can already export the Summarize Payroll Data to Excel.

 

Keep me posted if you have other questions about reports or transactions. I'm here to help you further. Wishing you all the best!

Experienced Member

Re: Summarize Payroll Data in Excel issue

I am having the same issue.  In our office we have multiple workstations all running on a network.  On Tuesday (1/8/19) , we had no problems running this report.  On Wednesday, about half our workstation were getting the Pivot Tables error and half could still run the summary report with no errors.  Today (Sat. 1/12/19), I am down to 2 workstation still being able to run the report without problems and the other 13 workstation having the issue.  We use multiple versions of QuickBooks Premier Accountant Desktop software and it doesn't seem to matter which year QB you are using they are all having the problem.  The two workstations that it still works on have their auto updates off, whereas all the other workstations are set to auto update.  I am resorting to using one workstation as a test case and wiping it and reinstalling MS Office and QB on it and not updating the QBs to see if that resolves the problem.  Then once we are past W2  prep season, installing the updates.  Not a good solution. 

Experienced Member

Re: Summarize Payroll Data in Excel issue

Hello,

 

I’m having the same isssue.  I got an error message when running the Summarize Payroll Data in Excel report. Once I click to fix the error, the repaired QB_Payroll _Link2 opens. The State Wage Listing Tab does not have the usual drop down box to choose SUI Company or FUTA for me to run the correct reports to send to the State of Florida and the Feds. I read one of the comments to do a super clean install and that’s just unacceptable and not practical.  We all need to submit this information ASAP, so please help in fixing this issue.  

 

Kind regards,

SanabellaSpa

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hello Angel, 

 

Currently, we've received reports regarding the issues when exporting payroll reports. Our engineers are already aware of this and working for a fix. I'd recommend contacting our Payroll Support Team to add your profile to the list of affected users. They can keep you up to date and provide further troubleshooting steps about this.

  1. Go to this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Select QuickBooks Pro/Premier United States in the upper-right corner of the page.
  3. In the first section, select Running Your Business in QuickBooks and Basic, Standard, or Enhanced Payroll.
  4. In the second section, choose how you want to reach them (phone or chat).

I appreciate your patience as we work for a fix.

Experienced Member

Re: Summarize Payroll Data in Excel issue

I am having the same issue with Enterprise 18.  I'm not going thru the trouble of re-installing QB on each computer when it isn't even an established fix.  It's tax season so hoping this gets immediate attention since so many are having an issue.  Thanks for posting.

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hello, @dyleva.

 

Thanks for sharing your thoughts here in the Community. I understand the impact of any delay in resolving this problem. Our engineers are doing the best they can to get this issue resolved as soon as possible. 

 

As soon as an update is received, I, or another member of the Community Team, will be happy to update this thread and let you know so that you can get back to business. But for now, I'd suggest contacting our Desktop Payroll Support so they can pull up your account in a secure environment and add you to the list of affected users. You can contact them with the instructions provided above by my colleague @JamesDuanT.

 

Let me know if you have other questions. I'm here to help however I can.

Experienced Member

Re: Summarize Payroll Data in Excel issue

Since it was mentioned in another post on this issue that Excel 2013 worked I decided to try rolling back the latest Office 365 updates. We knew the report ran back in November for us. I followed the attached instructions from the Microsoft Office support site and rolled back Office to the November 27 version - Build 11029.20079. This did allow us to run the Summarize Payroll Data in Excel report without incurring the errors and all tabs had the correct information in them. This is not a preferred solution as I want my Office 365 program to be up to date but at least it will allow us to do what we need to do this month. I still hope QuickBooks resolves the issue in relation to a current version of Office 365. Hope this helps anyone else having the error with this report. 

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Good day, casrookie,

 

Thanks for sharing this resolution with Community.

 

This is a great suggestion for our affected users to use while our engineers are still working to roll out a permanent fix for this Excel error. They're already investigating the root cause of this unexpected hitch.

 

While they do, we would suggest getting in touch with our Payroll Support Team to have you added to our notification list of affected users. Here's how you can contact us:

 

1. Go to http://payroll.intuit.com/support/contact/.

2. Select your Payroll Subscription type, then choose a topic.

3. Click on the View Contact Info button.

 

That should do it, casrookie. Once added, you'll get live email notifications once an update is available.

 

Please feel free to get in touch if you have anymore questions with QuickBooks. I'll be around to get thing all figured out for you. Have a good one!

Established Member

Re: Summarize Payroll Data in Excel issue

Just hung up w/Quickbooks Support to have them add us to the list of customers that are having this problem & was told to post it here instead. Please let us know when this problem with Summarizing Payroll Data in Exel is corrected.

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hello and welcome to the QuickBooks Community, The Copy Shop.

 

Thank you for providing us with details regarding what you did on your end about the issue. I'm here to help provide information about the investigation.

 

The issue with exporting QuickBooks payroll report to Excel is still ongoing. Our Product Development Team is working hard to resolve the problem as quickly as possible.

 

For now, the workaround available is rolling back to the previous version of Office 365. We'll keep you up to date through this thread as well once there are updates from the backend team.

 

Please don't hesitate to let me know what else I can do to help you today. The Community is always here to help.

Active Member

Re: Summarize Payroll Data in Excel issue

I was online with the Office 365 and they were unable to help!!

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hi, battleview orchards.

Allow me to share some information about summarizing payroll data in Excel.


Our Payroll Team is actively working to resolve this issue. I’d encourage you to contact our phone agents and have them attach your case to INV-24874, so they can add your account information to the notification list. That way, our engineers can send you updates via email when they are available.

 

However, as soon as an update is received, I, or another member of the Community Team, will be happy to update this thread and let everyone know so that you can get back to business.

 

You may want to check this article for more information: Excel based payroll reports

 

You can get our most-up-to-date contact number here:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

I appreciate your patience while this is being worked on. Please know that I'm just a post away should you need anything else. Wishing you a wonderful week ahead.

Experienced Member

Re: Summarize Payroll Data in Excel issue

I just want to add my problem here as well.  I have tried the "Chat" and basically got an automated "we'll get back to you" message.  But I want to be counted, so here's my spiel:

 

None of the computers in our office (8) can run the payroll reports in Excel. This started around October 1st, 2018.  I believe it began after program updates, but there were Windows, Office, and QB updates all around the same time.  We get the error on Win7 and Win10 machines.  We have no other issues except this QB problem connecting with Excel.

 

We are not using 64 bit version of Excel. We are using Office 365, and Office 2016, and Office 2013 & none of them connect to QB.  I tried repairing QB (only on my computer, no one else’s) but it wouldn’t work – it aborted.

 

This is the error message we get when trying to run QB reports that use Excel:

 

Could not connect to QuickBooks.

An Error occurred while attempting to find QuickBooks.

QuickBooks may not be installed properly on this machine.

Try restarting your machine.  If that does not work, repairing QuickBooks from the Windows Add/Remove Programs Control Panel may resolve this issue.

If you are using Excel 2010 64bit, this feature is not supported and will not work.  Consider using the 32bit version of Excel 2010.

Error 429:  ActiveX component can't create object

 

 

Experienced Member

Re: Summarize Payroll Data in Excel issue

I just want to add my problem here as well.  I have tried the "Chat" and basically got an automated "we'll get back to you" message.  But I want to be counted, so here's my spiel:

 

None of the computers in our office (8) can run the payroll reports in Excel. This started around October 1st, 2018.  I believe it began after program updates, but there were Windows, Office, and QB updates all around the same time.  We get the error on Win7 and Win10 machines.  We have no other issues except this QB problem connecting with Excel.

 

We are not using 64 bit version of Excel. We are using Office 365, and Office 2016, and Office 2013 & none of them connect to QB.  I tried repairing QB (only on my computer, no one else’s) but it wouldn’t work – it aborted.

 

This is the error message we get when trying to run QB reports that use Excel:

 

Could not connect to QuickBooks.

An Error occurred while attempting to find QuickBooks.

QuickBooks may not be installed properly on this machine.

Try restarting your machine.  If that does not work, repairing QuickBooks from the Windows Add/Remove Programs Control Panel may resolve this issue.

If you are using Excel 2010 64bit, this feature is not supported and will not work.  Consider using the 32bit version of Excel 2010.

Error 429:  ActiveX component can't create object

 

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hi there, Lori831.

 

Thanks for joining this thread. Allow me to help and provide an update about Summarize Payroll Data in Excel. 

 

I appreciate the information you've provided. Exporting Summarize payroll report to Excel is still ongoing issue, as of now, we haven’t received any updates yet if when this will be resolved. Rest assured that our engineers are currently investigating and working on an immediate fix. I also  encourage you to reach out to our Customer Care Team to add your account to the list of affected users. This way, you'll be notified of any updates on the progress on the investigation via email. 

 

You can contact our phone support by following the steps provided by my colleagues above.

 

We appreciate your patience as we work through this. If you have any other concerns, don't hesitate to inform us. We're always here to help you out. 

Community Contributor *

Re: Summarize Payroll Data in Excel issue

I need to jump in on this as I'm having the same problem with Summarize Payroll Data in Excel using Desktop Pro 2017.  We all have state & Federal reports that are due.  When will this be fixed?

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hello, @Jeanne1213.

 

Thanks for reaching out and joining the thread. 

 

This has already been escalated and our Engineering Team is actively working to get this resolved. However, we don't have a specific turn around time yet when this will be available. 

 

I can pass along all the feedback you have to the appropriate channels and make sure your concerns are addressed accordingly.

 

In the meantime, you can run the report from previous quarters and then when asked to update, select yes and it'll be able to pull up the data correctly. If that does not work, clean install of QB and Excel are possible fixes.

 

I'll be here to give you an update once the issue is resolved. Let me know if you need anything else.

mgw
Experienced Member

Re: Summarize Payroll Data in Excel issue

Same issue.  Been running State Wage Listing in excel for 15 years.  Need it by the end of the month for filing purposes.  Please keep me updated.  Thanks.

QuickBooks Team

Re: Summarize Payroll Data in Excel issue

Hi, mgw.

 

Thanks for joining this thread. Allow me to provide some additional information about Summarize Payroll Data in Excel. 

 

Right now, exporting summarize payroll report to excel is still ongoing issue. Our engineers are currently investigating and working on an immediate fix. Rest assured, we’ll keep you posted once the issue is resolved. I also recommend reaching out to our Customer Care Team to add your account to the list of affected users. This way, you’ll be notified of any updates on the progress of the investigation via email. 

 

You can contact our phone support by following the steps provided by my colleagues above.

 

For the meantime, you may follow the workaround provided by colleague @LilyC

 

Feel free to leave a comment if you have any other concerns. Community team will always here to help.