I'm using Windows 10 home, QB Premier Contractor and Excel 2016 via Office 365 and am having the same issues. Thank you for posting your work around - it really helped me out.
Hi there, @WCP.
Thanks for joining this thread. Allow me to provide some update about the excel issue in QuickBooks Desktop.
I've checked the investigation status about this issue, and it's still in progress. Rest assured that our engineers are investigating and working on an immediate fix.
I also recommend contacting 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 phone support:
We appreciate your patience as we work through this. Don't hesitate to leave a comment below if you have any other questions. I'm always here to help.
Thanks for getting back to us, WCP.
To answer your question, yes. This way, you'll able to receive an update through email once the investigation is already resolve.
Have a great day ahead.
I've phoned QB over 4 separate times (who has the time to be on the phone with the same non-effective response) and QB keeps saying it's a MS problem. MS did troubleshooting of my Windows (no issues) and I've repaired, reinstalled QB, turned off the UAC and even bought a standalone Office 2016 out of desperation (one agent said QB wouldn't integrate with 365 despite me using it for the pat 2 years). This is the end of March so the problem has been floating around for two months. I get the csv option for reporting. Grrh.
Hi there, @susan_new.
Thanks for reaching out to the Community today. Allow me to join this conversation and provide you with some details about exporting an excel file in QuickBooks Desktop.
Office 365 should work since it is compatible with the supported versions of QuickBooks. If you only have the option is to export to a CSV file, this can be caused by the following reasons:
• Excel is not installed on your computer.
• It's installed across a network.
• The local Excel installation is damaged.
To single this issue out, you'll need to toggle the UAC in Windows.
Let me guide you how:
Here's a great article that will provide you more details on how to perform the process: Export option for Excel is grayed out.
That should do it.
Please give this a try and let me know how it goes. If you have any questions, leave a reply below. I’ll be here to answer them for you. Thank you for reaching out and take care!
Thank you for this information; however, I would like to point out the problem is not with the export to Excel option being grayed out or only having the option to export to a CSV file. The problem this thread is referencing is the missing drop down menu in the State Wage Listing tab next to "Tax Tracking". Therefore, a different tax cannot be chosen and only one tax is shown.
Following is what occurs when trying to export the information to Excel:
"Reports" - "Employees & Payroll" - "Summarize Payroll Data in Excel" - then this pops up: "We found a problem with some content in 'QB_Payroll_Link.xlt'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." When you select "Yes", and the dates you want to export, another window pops up that says, "Excel was able to open the file by repairing or removing the unreadable content." Which is then followed by two lines of the same information that say, "Global PivotTable report information was repaired due to integrity problems." then select "Get Quickbooks Data". On the State Wage Listing tab, row 3, there used to be a filter/drop-down button in column B, now all that shows is "Medicare Additional Tax" in row 3, column B without the ability to select any other taxes.
This has been a problem since January. We will be needing to file quarterlies next month and this is part of what we use for our reports. I am hopeful this problem will be fixed prior to needing that information as this has been a very long time for the problem to be going on.
Any updates on this specific problem would be appreciated.
Hello there, @WCP.
I'm here to help you and point out your Summarize Payroll Data in Excel issue.
There's an option to select multiple items on row 3, column B on the Excel file. Just make sure to put a check mark on the Select Multiple Items box. Please refer to the screenshot below so you can have a better view:
Let me know if you have a different interface from the image above. I'd also appreciate if you can attach a screenshot of your screen.
You can mention my name or you can click "Reply" so I'd be notified. Have a good one.
I appreciate the screenshot you've given, @WCP.
I'd like to share some clarifications about the missing drop-down menu in the State Wage Listing tab when exporting a report to Excel.
I've tried pulling this report on my end using Microsoft Excel 2010, and the drop-down menu shows up. For now, you can try checking out your Excel version if it meets the QuickBooks Desktop system requirements.
If so, I'd suggest reaching out to your IT professional for further assistance. This way they'll be able to check the functionality of your excel. If there's no identified problem on your Excel, you may contact Microsoft directly so they can further investigate what's causing the issue.
This information should get you going today.
Keep me posted if you have any other questions about this concern. I want to make sure you're taken care of. Have a good one!
It's a sad state of affairs, but I appear to have found a work around. It involves uninstalling Office 365 and installing Office 2010.
I am (was) using a local version of Office 365, which has not worked for payroll exports (with pivot tables) since upgrading to Enterprise 19.0
After trying every possible fix within this thread (unsuccessfully) and contacting QB support, which had no solution, I had an idea. I uninstalled Office 365 and downloaded Excel 2010. I did have a product key, but have not actually activated it yet.
I was able to successfully export the payroll report "summarize payroll data in Excel" into Excel 2010 with pivot tables intact. It's not a perfect solution, and there are still some pop ups to ignore, and likely some security risks being that it's not an updated version. But, if you rely on this info for quarterly reports (as I do) and have struggled through every other unsuccessful attempt to export this data, it might be worth the trouble. It was for me. I intend on reinstalling Office 365 as soon as I'm finished with it. Hopefully this helps out someone as desperate as I was to find a solution, even if just temporary, until QB resolves the issue.
I was having the same issue with this report and getting our Ohio Unemployment report to run for 1st quarter 2019.
Our IT guys rolled back Microsoft Office on my computer and also disabled Microsoft Office from installing updates. I was able to run, print and save the report this morning.
IT turned Office updates back on after I ran the report and Excel is back to the normal version.
I hope QB fixes this by the time we have to run 2nd quarter reports, but if they don't there is a work around.
Update: I tried running the QB repair and it failed. I ended up uninstalling and reinstalling to the latest update of Quickbooks 2019 (I had R5 and downloaded the install file R6). Side note: Ever since the December QB update, I was also having issues with the actual QB program not opening! I would have to restart my computer (sometimes twice) before it would actually open the program. I had no issues with any other program on my computer. It finally stopped opening altogether, which is what prompted me to try the repair (which failed) and then the uninstall and clean install. I was hopeful that all my problems were solved, but alas they are not. I still am unable to to export the payroll data to excel and am getting the same pivot table error. In fact, under the State Wage Listing tab, it doesn't even have our employee data--it's just generic. I have updated my excel program (I am running Office 365). Still no luck. I am sure the problem lies in the QB program itself. Are you any closer to getting this fixed? It's been 5 months with no solution.
You need an earlier version of Excel, not the most current Office 365. Talk to your IT department and see if they can revert back to an older version of Excel. Doing this worked for me today. Or you can go to the Payroll center and then click on the File Forms tab. Scroll down and choose the UI Qtd Report - it will give you the same information you need.
Fresh install of Ent 18 on a new Win 10 Pro and Excel 16 and I still get this Summary report generating a Pivot table error. When is this going to be fixed? Is this something that warrants us moving to Ent 19? Is this problem resolved in v19?
I have verified that this issue is still on-going, htrumbull.
Our product engineers are working their best to resolve this issue as quickly as they can. Also, there is no specific time frame as to when this issue will be fixed.
I'd recommend reaching our Customer Care team to have you included in the list of the affected users. This way, you will receive any updates about this issue via email.
Here's how to contact them:
I appreciate your patience while we are working to fix this for you. I'd also make sure to keep you updated with this.
I just tried to run the 2nd Quarter 2019 Ohio Unemployment report and I am still getting the same error as I did for the 1st Quarter 2019.
I am wondering why this has not been fixed yet by QB.
Welcome to the Community. I want to assist you with the Ohio Unemployment report in QuickBooks Desktop.
Can you share with me the specific error message you encounter when you run the report? Are you referring to the Employer's Contribution and Quarter Summary/Reimbursing Wage Detail form? Any additional clarification like screenshots will ensure a timely solution.
In the meantime, I recommend running the payroll updates to ensure you have the latest federal tax tables and tax forms. Having the latest version will help ensure quarterly reports will populate without any issues.
Here are the steps:
I'm also adding a sample screenshot below:
For additional insight into the payroll tax table, such as the updating process, I'm attaching an article that I recommend:
As always, you can reach out to me for any concerns you may have with payroll. The Community will be around to lend a hand.
I truly understand the impact of any delay in resolving the ongoing concern with the missing drop-down menu in the State Wage Listing tab when exporting a report to Excel. Our Product Engineers are still working on releasing a permanent resolution to fix this unexpected behavior.
Although, I can’t provide you with the specific time frame on when this will be fixed. Rest assured, as soon as updates are released it will be applied automatically into your account. Also, you'll be informed about it through an email.
In the meantime, you can run the report from previous quarters. When asked to update select "Yes" and it is able to pull all the data correctly. If that does not work clean install of QB and Excel are possible fixes.
To clean install QuickBooks, here's how:
You can refer to this article for more detailed steps: Clean install QuickBooks Desktop.
Let me know if you have other questions. I'm just a few posts away.