cancel
Showing results for 
Search instead for 
Did you mean: 
AJ39
Level 1

error 107320

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
Best answer January 28, 2020

Best Answers
BigRedConsulting
Community Champion

error 107320

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! 

View solution in original post

45 Comments 45
casrookie
Level 2

error 107320

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.

Rose-A
Moderator

error 107320

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:

 

  1. Restart your computer to close unnecessary programs interfering with QuickBooks.
  2. Back up your QuickBooks company file.
  3. Select Start and then Control Panel. (In Windows 8/8.1: From the Start menu, open Search and type Control Panel. From the results, select Control Panel.)
  4. Select Programs and Features. If necessary, choose the Uninstall a program.
    Note: If you don't see these options, select Programs, then Program Features.
  5. Select QuickBooks in the list of programs and choose Uninstall/Change.
  6. Select Continue, then, Next.
  7. Select Repair then Next. Wait for the Repair to complete.
  8. Choose Finish,  then restart your computer if prompted.
  9. Don't forget to download the latest QuickBooks release and the latest payroll tax table when you open QuickBooks.

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:

 

  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 wish you continued success with your business. Please let me know if you have any other questions.

casrookie
Level 2

error 107320

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.  

Adrian_A
Moderator

error 107320

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:

  1. Go to this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Click the Employees & payroll link, then choose General payroll help.
  4. Click the Get Phone Number or Start a Message button.

We appreciate your patience with this matter and let me know if you have any other concerns.

 

gsgbpc
Level 1

error 107320

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.

Charies_M
Moderator

error 107320

 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. 

gsgbpc
Level 1

error 107320

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.

ssmaupin
Level 2

error 107320

Same issue here.  Using Office 365.

IamjuViel
QuickBooks Team

error 107320

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:

  1. Visit: https://help.quickbooks.intuit.com/en_US/contact.
  2. Select your QuickBooks Product.
  3. Choose 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.

Keep me posted on how things work on your end. I’m always here to help successfully your payroll reports. Have a great ahead!

casrookie
Level 2

error 107320

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. 

IamjuViel
QuickBooks Team

error 107320

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!

BrandonT
Moderator

error 107320

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”

casrookie
Level 2

error 107320

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.

casrookie
Level 2

error 107320

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.

AlcaeusF
Moderator

error 107320

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.

DDoctors
Level 1

error 107320

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? 

Rasa-LilaM
QuickBooks Team

error 107320

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:

 

  1. In your browser, enter this link: https://help.quickbooks.intuit.com/en_US/contactus.
  2. Select QuickBooks Desktop.
  3. Choose your QuickBooks for Windows version.
  4. Select the issue/topic.
  5. Click the Get Phone Number button to see the support number.


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.

 

mike126
Level 1

error 107320

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. 

SkyQueen
Level 2

error 107320

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.  

 

AlcaeusF
Moderator

error 107320

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:

 

  1. Go to: https://payroll.intuit.com/support/contact/.
  2. Choose your payroll subscription.
  3. Select Payroll.
  4. Click View Contact Info.

Please reach out to me here should you need any additional assistance. I'm always up to talk with QuickBooks.

laurieWalt
Level 1

error 107320

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.

ShiellaGraceA
QuickBooks Team

error 107320

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.

  1. Go to https://payroll.intuit.com/support/contact/.
  2. Click the Basic, Standard & Enhanced button.
  3. Click Payroll.
  4. Click View Contact Info.

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.

vedwards
Level 1

error 107320

Iam unable to get my paycheck information. Iam with Disability Action Centyer

vedwards
Level 1

error 107320

Iam unable to get information on my time sheet. Iam with Disability Action Center

Need to get in touch?

Contact us