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!

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. 

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

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.

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.

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. 

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.

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.

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

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.

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. 

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?

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.

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 @Anonymous. 

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

We are having the same problems.

This is tax season.  I need this report.  There does not seem to be any other way of getting that data summarized for our State Wage Listing or Quarterly.  

I contacted QB as well as Microsoft.

Thank you

Hi there, AllWeather.

Thanks for dropping by here in QuickBooks Community. Let me provide some update about the Summarize Payroll Data in Excel issue.

The status of this investigation is still in progress. Our engineers are still reviewing the data and working through the troubleshooting to determine what is causing this issue. Since we still haven't received any updates yet if when this will be resolved, I recommend calling 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. 

Here's how you can contact our phone support: 

1. Click this link: https://help.quickbooks.intuit.com/en_US/contact.
2. Select the version of QuickBooks, click Contact Us.
3. Type-in Technical Support on the search bar.
4. And click Get the Phone number below.

We appreciate your patience as we work through this. Please know that you're always welcome to post if you have any other questions. Community team will always here to help. 

I need to be added.  I am having the same issues and had the issues last month, but manual figured them to get reports finished on time.  Thank you, Lori Conner ([email address removed])

Hello there, @connermom.

I’m glad you were able to get around the issue and meet the deadline.  

Adding you to the list of affected users requires the checking of your account. Since we won’t be able to do that here in the Community for security reasons, please give our Payroll Care Team a call for assistance.

They can create a case and attach it to INV-24874 to receive important updates about the investigation. When there is new information provided, an email notification will be sent to you.

Here’s how to contact phone support:
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.

We appreciate your patience and understanding. 

Please let us know how it goes after contacting them. Get in touch if you have any additional questions. I’m always here to help. Thanks for dropping by and take care!