cancel
Showing results for 
Search instead for 
Did you mean: 
QuickBooks Team

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Hi Kathy31,

 

I've seen an open ticket about this issue. Our engineers are still gathering data for their investigation. I suggest giving us a call to get you added to the list. This way, you will be notified when it's fixed. 

 

In the meantime, please follow the steps above provided by one of our user's Jeanne1213 (Install an older version of MS365 and turn off auto-updates.)

Note: Office 2019 is not supported at this time.

 

Let us know if there's anything else you need. We're here to help.

Community Contributor **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It says we found a problem with some content in QB-Payroll_Link.xlt. Does anyone know how to fix this?

When will this be fixed as I still am unable to retrieve these reports. My ref# [removed]
QuickBooks Team

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

This is still under investigation, Nmacdonald.

 

We're unable to provide a time frame to when this will be fixed. Rest assured, our engineers are doing their best to find a solution. 

 

To get around the error, run the report from the previous quarters, then select Yes when asked to update. You'll be able to pull up the data correctly by doing this.

 

If it doesn't work, uninstall and reinstall QuickBooks using clean install. Before doing so, make sure to create a back up of your company file to avoid any accidental data loss. 

 

On the other hand, some of our users are able to summarize the payroll data in Excel by rolling back the Microsoft Office updates.

 

If you haven't contacted us, I suggest getting in touch with our customer care support so they'll add you to the list of affected users. Here's how:

  1. Click Help inside QuickBooks.
  2. Go to QuickBooks Desktop Help.
  3. In the Have a Question? window, click Contact us.
  4. Provide a brief description about your issue, then click Continue
  5. Select either Message an Agent or Talk to a Specialist

Please do know we're just here if you have other concerns. 

Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

It is now August  - Inuit has known about this bug since January when it started to affect a good deal of their clients.  How is it that this has not been fixed yet?  This needs to be moved higher up on the priority list, ASAP!

Moderator

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Hello Kathy31,

 

I'm here to help provide information about exporting payroll data to Excel in QuickBooks Desktop.

 

The time frame on when the issue gets fixed will depend on the updates made from the third-party application. Our product engineers are working hard with their support to ensure you'll be able to export the payroll data.

 

While waiting for the complete resolution, I recommend using the workaround available. You can run the report for previous quarters and when asked to update, select Yes.

 

It usually helps pull up the data correctly from the QuickBooks program. I also suggest contacting support to ensure you'll be part of the list of affected users (investigation number INV-24874).

 

Here's how you can reach them:

 

  1. Open QuickBooks Desktop.
  2. Cick the Help tab at the top menu bar.
  3. Click QuickBooks Desktop Help.
  4. Click the Contact us hyperlink.

Let me know if you need further help or concerns with exporting payroll data to Excel, and I'll be sure to get back to you.

Community Explorer **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Jumping on the bandwagon here.  If someone knew where the xlt file was stored, we could probably wipe it or replace it with a working copy and all move forward.

QuickBooks Team

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Hi there, @spittlbm.

 

I'd be glad to help you today so you'll be able to locate your xlt file.

 

First, you can search the file by going to your folder and look for xlt or the file name on the upper-right side of the page.

 

However, if you're using the Office 365 or Excel 2019, you may encounter the error message as stated in this thread. If so, I recommend getting in touch with our Support Team. This way, they'll be able to add you to the list of affected users and receive an email notification for the latest updates.

 

For the support's contact information, you can check it here: Contact the QuickBooks Desktop Customer Support Team.

 

Let me know if you have any other questions. I'm always available to help!

Community Contributor **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

I agree.  This should be at the highest priority.  I rely on these reports for my quarterly taxes not to mention year-end.  This might sway me to change software's.  

 

The go around by selecting 'yes' only gives me corrupt files and is useless.

Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Is there a fix for this?  This has been happening on and off to me for the past year.  Very frustrating for the amount we pay to be an enterprise customer with support.  Don't think I have ever received an update on problems encountered within QB.

Anonymous
Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

I'd like to help share the update, @randy1721.

 

Our Engineering Team is currently working for a fix regarding this issue. If you've already contacted our support and signed up as one of the affected users, we'll surely communicate to you once the status of the behavior changes.

 

Please bear with us while we work to find you a solution. In the meantime, you can check out our QuickBooks Product Updates to keep you in the loop of what's new and what's coming.

 

I'll also be around to help if you have additional questions about your payroll data. 

Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It says we found a problem with some content in QB-Payroll_Link.xlt. Does anyone know how to fix this?

I also did some excel works and faced with this problem and updated my excel and disabling all of the faulty add-ins and fixed the problem helped by the sitehttps://msofficetechnicalsupportnumbers.com/blog/how-to-fix-ms-excel-has-stopped-working-error/

Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

This is the only post that really helped me...I've done everything they've asked, reboot, uninstall, reinstall, etc., etc., and everything else I can think of except to strip naked and cluck like a chicken around a campfire, all to no avail with no way to easily file the SUTA return.  We who have many returns to file are desperate...here's another really "icky" part...I'm a ProAdvisor...when I call ProAdvisor support, they simply want to spend 1.5 hours with me on the phone, doing it all over again.  I don't understand...why doesn't someone put their foot down AND GET THE PROBLEM FIXED??  This has been going on for at least throughout 2019...what is it that we must do in order for the very software we tout to our clients to purchase and use (and that we ourselves pay for) to actually work??   Best clear my throat...clucking is the only possible solution I've not tried.

Highlighted
Anonymous
Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

So, in summary, Intuit posts on this topic:

 

01-23-2019 Angelyn_T: As mentioned by my colleagues above, there's an ongoing issue/error when using Summarize Payroll Data in Excel. Our engineers are all hands on deck working together for an immediate fix.


01-24-2019 Rasa-LilaM: This has already been reported as an ongoing issue with QuickBooks Desktop Payroll and our product developers are diligently working to fix this as soon as possible


01-26-2019 Kristine Mae: We're unable to provide a specific time frame to when this will be fixed. Rest assured, our engineering team is working diligently to get this fixed.


02-23-2019 JanyRoseB: Allow me to jump in and provide some update about the error when using Summarize Payroll Data in Excel feature in QuickBooks. I've checked the investigation status about this issue and it's still in progress.


04-02-2019 MaryLandT: Our engineering team is still investigating the cause of the error when generating the Summarize Payroll Data in Excel report.


04-09-2019 JanyRoseB: Our engineers are continuing to work on solving for this unexpected behavior and rest assured that updates will be sent to you once this gets resolved.

 

04-11-2019 MaryLandT: While our engineering team is still working on the resolution to fix the issue,...


04-29-2019 ShiellaGraceA: I've seen an open ticket about this issue. Our engineers are still gathering data for their investigation


08-06-2019 Kristine Mae: This is still under investigation, Nmacdonald. We're unable to provide a time frame to when this will be fixed. Rest assured, our engineers are doing their best to find a solution.

 

08-06-2019 AlcaeusF: The time frame on when the issue gets fixed will depend on the updates made from the third-party application (Microsoft).

 

I can't wait to see the next update.  I'm holding my breath.

 

Experienced Member

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Any update on this yet QB?? Updated to 2019 from 2016 Mac Desktop because you "wouldn't be supporting" 2016 anymore.... and I can't export anything now! Looking through this thread, looks like it has been an ongoing issue for more than TEN MONTHS!!! I need to send info to my accountant, I have tons of reports I need to update from the past months and I can't do any of it! Any timeline yet on a fix?? Need this done more than ASAP!

Moderator

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

The affected users on this thread are using QuickBooks Desktop, MAD6400.

 

Let's try to reinstall QuickBooks for Mac using clean install. Let's start with uninstalling QB Mac, make sure to have your QuickBooks Desktop download file (or installation CD) and license numbers ready.

  1. Close QB Mac.
  2. Go to the Finder menu, then select Applications.
  3. Drag the QuickBooks icon to the Trash.

Follow the next steps on this article to successfully reinstall QB for Mac: Reinstall QuickBooks for Mac using clean install.

 

Don’t hesitate to reply below if you got additional concerns, I’m always here to help you.

Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

thanks.....??  I don't have a Mac...this has nothing to do with QB for MAC...

Community Contributor **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

I've tried all the recommendation and NOTHING is working for me and probably many other users.  When is Intuit going to get this issued fixed.  Do they not realize how we depend on these payroll reports to compile taxes?  Is this not a priority for them?  Do they just not care?  I don't understand how such a big company can allow this to continue for so long.  I have a renewal coming up, why would I renew versus getting a different accounting software?

 

Last I heard, was that Intuit was suggesting that we wait on MS to provide an update to their software....guess what?  That didn't work

Anonymous
Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

@MaryLurleenM 

The Summarize Payroll in Excel feature does not exist on the mac.  Everybody knows that.

 

Anonymous
Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

re: When is Intuit going to get this issued fixed. 

 

It's only been 10 months. 

 

Based on Intuit's posts here and elsewhere, basically the entire engineering team is working diligently on this 24x7. Must be a hard nut to crack.

Community Contributor **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

The error message that you/we are receiving is because Intuit cannot support/work with MS 2019.  Everything was fine until we updated to the newest version of Microsoft.  I just don't get how the techs at Intuit cannot figure this out.  Maybe Intuit needs to outsource their IT to get this resolved.

Experienced Member

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Mary, Same issue after following your directions. I guess I just figured it was the same issue everyone else was having, not being able to open reports into Excel. See attached screenshot

Community Contributor **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Have you found another way for the Futa?

Anonymous
Not applicable

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

I reviewed the file.

 

I see errors when using Excel 2016, as well as Excel 2003.  The file has two corrupt Pivot Table reports that need to be fixed - the State Wage Listing and the Quarterly Employee Summary.

 

Also Intuit has, probably accidentally,  Introduced two links to external data sources - named ranges that point to external sources.  That in and of itself shouldn't cause the error message, but it's distracting and incorrect.

 

Neither of these issues are very hard to fix.

Community Contributor **

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

So, again it comes back to Intuit.  They are glad to take our money, but just cans seems to give a rats behind at fixing this.  I seriously think they need to get some new IT people.  I know if I don't do my job, my boss would not hesitate in letting me go.  

 

Thank you for your response and feed back.

Nancy

Frequent Explorer *

Re: I keep getting a Microsoft Excel error message when I summarize payroll data in Excel. It say...

Y'all might need to consider shutting off MS 365 updates until Intuit figures this out.  I don't understand for the life of me why its still not fixed.  Shame on Intuit! 

Need to get in touch?

Contact us