Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
When I'm working in QB and try to summarize payroll data in excel it says we found a problem with some content in "QB Payroll Link xlt Do you want to recover. When I say "yes" it starts to figure my reports along with a pop up window that says repairs to QB payroll link2 excel was able to open the file by repairing or removing the unreadable content and global pivottable report information was repaired due to integrity problems. It does give the correct figures in the employee journal tab but when i open the quarterly tab the totals are not there at all
Solved! Go to Solution.
It has been about four years now and Intuit has still not fixed the issue. I'm sure they're still working hard on it as promised here multiple times.
It was easy enough to fix and took a couple of hours, including testing the fixes and then creating a page for downloading.
------Update-------------------------------
We recently added support for QuickBooks 2022 as it has to be different because it's 64bit.
You can download the fixed version from our site, no charge: BRC Summarize Payroll Data In Excel – Fixed!
Spent about 5 hours on the phone in total today with support which was a total waste of time. Watched them uninstall and reinstall both QuickBooks and Excel multiple times. They had me do a new install on my laptop and test it – no difference. They seem to be blaming the fact that we are running Office 365 for the issue and wanted me to load an older version of Excel (which I don’t have and wouldn’t have done anyway). What version of QuickBooks and Excel are you running?
Not sure why they won’t look at the file specified in the message QuickBooks_Payroll_Link.xlt. If Excel says there is unreadable content in the template than the two tabs that are messed up will be messed up no matter what version of Excel you run. Can’t wait for them to call me back in the morning and start all over.
Welcome to the Community everyone.
I'd be happy help you get past this error. Let's get this sorted out.
In order to resolve this issue, you can try to repair your QuickBooks.
Here's how:
For detailed information, check out this recommended article: Repair QuickBooks Desktop.
If the problem persists, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours:
I wish you continued success with your business. Please let me know if you have any other questions.
The advice you gave me is exactly what we did both Friday and Monday with the help of the support team. It did not fix the issue. We uninstalled both QuickBooks and Excel multiple times and reinstalled. We also downloaded and installed QuickBooks on my laptop which had never had QuickBooks installed on it prior and still got the same error message. i still believe the error resides in .xlt file and has nothing to do with my installations but apparently reinstalling QuickBooks does not fix the .xlt file.
I appreciate you sharing all the steps you've done, casrookie.
At this time, I recommend calling our phone support team. With their other tools, they can check your company file further and help you fix your report.
Here's how you can contact them:
We appreciate your patience with this matter and let me know if you have any other concerns.
This is so asinine. I'm having the same issue on multiple workstations and multiple versions of QuickBooks. Uninstalling, reinstalling, repairing...nothing is working. Stop insisting we contact support if it's just going to be the same unproductive suggestions.
Hello there, gsgbpc.
I appreciate you for performing some of the workarounds to try and resolve it ahead of time.
If you're still getting the same error after performing all the recommended steps above, I suggest you get in touch with our QuickBooks Care Support Team so they can open a new investigation for this.
You can get our Payroll Phone Support number that provided above by my colleague AdrianRose_A .
Please keep in touch with me if I can help you with anything else. I'm always around to help you whenever I can.
Here's what I learned from chat. And it somewhat resolved my issue.
This feature is not compatible with Excel 2019 yet.
It was compatible with Excel 2016 but the most recent Microsoft update broke it. You could try rolling back that update.
It works fine with Excel 2013, which I still had installed on one workstation, so that worked for me.
Hello there, @ssmaupin.
Managing your business is busy enough without the accounting and tax preparation on it. Allow me to share additional information on how you can export your payroll reports.
Microsoft Office 365 is a supported version in exporting your reports if it's locally installed and not the web version. In the meantime, let's try using an older version of Microsoft Excel in exporting your reports. Ensure to download the latest QuickBooks release and the latest payroll tax table prior doing the export.
You may also check out the articles below for a more detailed information:
If the error persists, I'd suggest contacting to our Technical Support Team. An agent will look into your account on a secured environment to further check the root cause of the issue.
Here's how:
Keep me posted on how things work on your end. I’m always here to help successfully your payroll reports. Have a great ahead!
Since it was mentioned 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.
Hi there, @casrookie.
Thank you for joining the thread and for sharing the steps you performed on your end.
Currently, QuickBooks Desktop supports the older version of Office 365. I understand how important it is for you and your business for QuickBooks to work with the latest version of Microsoft Excel. I'll surely forward this to our Product Developers for future product updates.
If the issue persist, you can reach out to Microsoft Tech support or an IT professional to further help you in repairing Office on a secured environment.
You can post anytime if you have other questions about exporting your payroll reports. Have a great day ahead!
Some customers have reported being able to click past the error. Here's another potential workaround and I'm looking for confirmation on it's viability so that I can update the report to our product developers.
Workaround: Just hit “Yes” to the first error, then allow 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”
The report does run if you do that but the State Tax Wage Listing and the Quarterly tabs do not have correct information in them nor will they have the drop down choices to switch between the various tax types on the State Wage Listing tab. The tabs prior to the State Wage Listing tab are all correct but we use the State Wage Listing tab for multiple things in our company.
The report does run if you do that but the State Tax Wage Listing and the Quarterly tabs do not have correct information in them nor will they have the drop down choices to switch between the various tax types on the State Wage Listing tab. The tabs prior to the State Wage Listing tab are all correct but we use the State Wage Listing tab for multiple things in our company.
Hello there, casrookie.
Thank you for posting in the Community. I want to be one who will help assist you with using the up to date Office 365 for your reports. However, we have limited access to this public space.
For now, you can roll back your Office 365 to the November 27 version as you've stated above. I'm adding this feedback myself on our internal product enhancement list that we submit directly to our product developers.
I also encourage you to send feedback directly to our website:
https://quickbooks.intuit.com/commerce/common/fragments/feedback.jsp.
Please remember I'm here anytime you need help with QuickBooks. The Community is always here for you.
Did you find a resolution to this? It sounds like after the Microsoft update it broke this connection and export process. Quickbooks need to get with their developers and get this fixed. Every operating system will have security patches and updates that QB needs to plan, program, and implement after these patches are released. After wasting hours on the phone with QB tech support, they say its not their issue but a Microsoft problem.
I have:
Uninstalled Microsoft Office
Uninstalled QB
Updated all security patches for Windows 10.
Cleaned Temp Files, cleaned Registry
Reinstalled Quickbooks & Office
Installed all patches / updates to both software
Still no go.
Whats the deal QB? Do I sense SAGE in my future along with all my clients we support?
Hi there, DDoctors.
Thanks for letting us know the steps you’ve taken to resolve the issue and contacting our Technical Support Team. Allow me to step in for a moment and share some information about the error.
I looked into this further and our engineers are all hands on deck working for the permanent resolution. While we don't have any workarounds, I recommend contacting our Technical Support Team again to make sure you've been added to the affected users' notification list.
This way, you’ll receive an email once an update is available. You can reach them through the following link:
Rest assured, we’ll be updating the thread once the patch is released.
I appreciate your patience while we look into this. If you need some help while working in QuickBooks, post a comment below. I’ll be happy to assist you further.
I'm having the same issue as DDoctors and tried the same fixes and still nothing. I agree Sage is in my future too. It seems I spend more time trying to find fixes and workarounds for Quickbooks on these forums than I do working in client files anymore.
I am having the same problem with Summarize Payroll Data in Excel.
We have converted to Office 365 over year end.
I wish to be put on a contact list when the fix is available.
Hi there, SkyQueen.
Thank you for dropping by here in the Community. It would be my pleasure to help provide the information regarding the payroll report.
We've received reports from other users getting the error when using Summarize Payroll Data in the Excel feature. To receive updates from our product developers about the ongoing investigation, I recommend giving us a call.
One of them will be able to add you to the list of affected users. You can take note of the investigation number INV-24874 and provide it to the representative.
I'm adding the steps below for you to reach them:
Please reach out to me here should you need any additional assistance. I'm always up to talk with QuickBooks.
I have to add my name to the list of people having this problem. Have tried all of the "work - arounds" listed above and NONE of them worked. I use the State Wage Listing report every quarter and have done so for the past 11 years. Suddenly it's not working and it's very frustrating that obviously other people are having the same problems and Intuit isn't getting on this to fix this quickly at a time of year when we're all running quarterly reports.
Hi laurieWalt,
This is already a reported issue. Our engineers are still gathering data for their investigation. To get you added to the affected users, please give our Payroll Team a call.
In the meantime, you'll want to run the report from previous quarters and then when asked to update select "Yes" to pull all the data correctly. If that does not work clean install of QuickBooks and Excel are possible fixes.
We're here if you need have other questions.
Iam unable to get my paycheck information. Iam with Disability Action Centyer
Iam unable to get information on my time sheet. Iam with Disability Action Center
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here