Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
sissya
March 7, 2019
Question

Error message: QB_Payroll_Link.xlt

  • March 7, 2019
  • 5 replies
  • 32 views

How can I fix this error message that I'm getting. I've been receiving it for over a month now.

    5 replies

    A
    Anonymous
    March 7, 2019

    What error message are you getting?

      M
      Mark_RModerator
      Moderator
      March 7, 2019

      Hello there, @sissya.

       

      Let me share two scenarios and help you with your concern about the error message you're getting.

       

      Just to clarify, are you trying to summarize the payroll data in excel? If so, QuickBooks Desktop Enterprise has an on-going issue where users are getting those errors.

       

      As a workaround, you can run the report from previous quarters and then when asked to update select Yes to pull all the data. If that doesn't work, I suggest a clean install of QB and Excel.

       

      But if you're trying to do something aside from summarizing the payroll data, you'll need to update your payroll tax table. Let me guide you how:

       

      1. Go to the Employees menu, then select Get Payroll Updates.
      2. Put a check in the Download Entire Update checkbox.
      3. Select Download Latest Update.

      After updating the tax table, a window will appear when the download is complete. Here's an article you can read for the detailed steps and information: Download the Latest Payroll Tax Table.

       

      Also, I recommend scheduling a callback with our QuickBooks Customer support so they can add your account to the list of affected users. This way, you'll receive an email regarding the issue once updates become available.

       

      Here's how you can schedule a callback:

       

      1. Log in to your QuickBooks account.
      2. Click on Help.
      3. Select Contact Us.

      Thank you for your patience as we work for a fix.

      A
      Anonymous
      April 17, 2019

      Just and FYI, I did all the steps you suggested.  Even updated/repaired Excel.  Nothing!  I was able to pull reports I can use for my quarterly reporting but this report is the one that gives me all the information I need and I would like to have it!!  I see this has been going on for some time now.

        JaneD
        JaneD
        Level 6
        April 17, 2019

        Good day, Tracey1960.

         

        I appreciate you joining us in this thread. I've got some information about the error that you're getting.

         

        I was able to confirm that there's an ongoing issue with summarizing Payroll Data in the Excel files from QuickBooks Desktop. For now, you may want to give us a call to receive updates. When you do, provide this investigation number: 24847. 

         

        Here's how:

        1. Sign in to your QuickBooks Online (QBO) account.
        2. Go to Help.
        3. Click on Contact us.
        4. Enter your concern and click on Let's talk.
        5. Choose either Start a chat or Get a callback.

        From there, one of our agents will be able to pull up your account securely and add you to our notification list. I'll also personally reach out to them and gather some information on this, so I can update you once this has been fixed

         

        Thanks for your patience and understanding. Please know that this issue is being treated with utmost urgency. Leave a message below if you have any other concerns. I'll be around.

        M
        Mc2019
        October 17, 2019

        I was on the phone with QuickBooks technical support yesterday for almost an hour. We tried all the avenues to get the State Wage Listing report in Summarize payroll in excel. I have had this problem now for about a year and have tried numerous time to get a fix. All the other tabs on this summarize excel sheet are correct except the one I need for unemployment reporting purposes. I do not know why we cannot get this fixed??

          M
          Mc2019
          October 17, 2019

          I have QuickBooks 2019 Pro. I have been getting this message now for about a year. I have tried numerous time with QuickBooks technical support to get it corrected. Nothing works. Odd thing is all the other tabs in Summarize payroll data in excel report have the correct figures. Why can't we get this fixed?? We use these figures to file online unemployment reports.

            Adrian_A
            Adrian_A
            Level 8
            October 17, 2019

            I appreciate all the steps you've done to resolve this issue, Mc2019.

             

            As of now, there's till an ongoing investigation about error message you've got. Rest assured, our engineers are diligently working to fix this one. But, I have a workaround for you. 

             

            You can run the report from the previous quarters then, when asked to update select Yes. This way, it will pull up all the data.

             

            I also recommend getting in touch to our Phone Support team. They'll get your company info and add it to the list of affected users.

             

            We appreciate your patience while waiting for the permanent fix.

            N
            NAU2020
            January 9, 2020

            Is anyone know how to fix this? I was on the phone over 3 hours and didn't get resolved by quickbook support team. I need to get the summary payroll report ASAP

              BigRedConsulting
              BigRedConsulting
              Level 15
              January 14, 2020

              This issue is more than a year old now.

               

              I got motivated a couple of months ago and noted the error still exists in QB 2020, so I checked it out to see what was going on.

               

              I found several issues with the workbook and fix them. The fixes were easy and took a couple of hours to find, fix, and test.

               

              Then I published an updated version for people that need it.  Start here to get it: Summarize Payroll Data In Excel « Big Red Consulting 

                W
                Wats1414
                January 28, 2020

                Thanks for the fix Big Red Consulting.  This was a great fix.

                 

                  Need QuickBooks guidance?
                  Log in to access expert advice and community support instantly.
                  Terms & ConditionsAccessibility statement