cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Re: Export to Excel Failure

I find it absolutely absurd this is still not fixed. I posted a quick-fix back in January when I first discovered the issue. I didn't get much of a response, but it makes you be able to actually "Summarize Payroll Data in Excel" I've simplified it and posted to my firm's website. If you want to actually be able to use this feature to assist in quarterly reports, see the link below https://www.bctaccounting.com/summarize-payroll-data/
Level 2

Re: Export to Excel Failure

Hello,

 

This has nothing to do with getting payroll updates.

 

A screenshot of my error is attached.  This is when I go to reports, employees & payroll, Summarize payroll data in excel to run our quarterly ohio unemployment report.

 

Thanks,
Tina

QuickBooks Team

Re: Export to Excel Failure

Hello @tinahr,

 

Thanks for providing a screenshot.

 

Currently, we have an on-going investigation when exporting which report to Excel. Our engineers are working on why you're getting the error when pulling out reports in Payroll.
 
While we are working to fix the issue, we have a workaround that you can perform to ensure you're still be able to pull up a data. To run the report from the previous quarters and when asked to update, select YES and it'll able to pull up the data. If this won't persist, another suggestion would be clean install QuickBooks and Excel.
 
I've added a helpful article on clean install QuickBooks Desktop for Windows.
 
I'd still recommend contacting our QuickBooks Desktop Support team to add your account to the list of affected users. This way, you'll receive an email once updates are available.
 
Here's how to reach them:
 

1. Open QuickBooks Desktop.

2. Choose Help tab at the top menu bar (you can still do this without opening a company file).

3. Click QuickBooks Desktop Help or press the F1 key.

4. Select Contact us.

 
Stay tuned for updates and if there's anything I can help you with, please let me know. I'd be happy to help.
Level 1

Re: Export to Excel Failure

I was reserving judgement, but followed these instructions to a "t" and guess what? My gut instinct was right. This is not a fix whatsoever. 

 

I get the same error as shown in the screenshot supplied by @tinahr . Which is the same error I've received when running quarterly payroll reports for the last three quarters. Sadly, this was a waste of time, @ShallyMarR . 

QuickBooks Team

Re: Export to Excel Failure

Hello, @Melana.

 

Please know that this isn't the type of service we want you to experience. I've checked the investigation status about this issue, and it's still in progress.

 

Rest assured that our product engineers are still working on releasing a permanent resolution to fix this behavior. Once updates are released, it will be applied directly to your account.

 

In the meantime, I'd recommend reaching out to our technical support team they can add you to our notification list of affected users to receive live email updates about this issue.

 

Here's how:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Click your QuickBooks Product.
  3. Choose your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Select on the Get Phone Number button to see the support number.

Don't hesitate to leave a comment below if you have any other questions. I'm always here to help. 

Level 1

Re: Export to Excel Failure

I'm presuming that this is still an unresolved issue - correct?

 

Recently upgrade server to Server 2019, running a terminal server and Office 365.  Getting the same export error.

Moderator

Re: Export to Excel Failure

Hey there, BPorter808.

I've got you covered in exporting your report into Excel via QuickBooks Desktop.

 

To better isolate this issue, as an initial step, you may want to open a sample company file. This is to check whether this has something to do with your company file or QuickBooks Program.

 

z.PNG

 

If you're able to export and email the report in Excel format, we can verify and rebuild your data. The data verification process in QuickBooks is a tool that examines the health of your QuickBooks company data file.

 

To Verify Data:

  1. Choose Window at the top, then Close All.
  2. Choose File.
  3. Click on Utilities.
  4. Verify Data.

To Rebuild Data:

  1. Choose
  2. Click on Utilities.
  3. Rebuild Data.
  4. You will receive a warning message to backup your company file, press OK.
  5. Click OKwhen you get the message "Rebuild has completed".

If you're still getting the same result, I'd suggest getting in touch with our QuickBooks Desktop Support to this re-investigated.

 

  1. Within your QuickBooks Desktop, click Help at the top menu bar.
  2. Click Contact us.
  3. In order to route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
  4. We’ll provide you a few options. You choose which one is best for you

I'll leave you with some helpful articles:

 

Please get back to me if you continue to get the same results so I can look further into this. Have a good one.

Level 1

Re: Export to Excel Failure

RoseMarjorieA,

This issue persists even when using a sample file.

 

Downgrading Office 365, nor using a previous version of Excel, is a work-around that can be done in my environment.

 

QuickBooks explicitly lists Office 365 as a compatible product for running Excel reports, so I suggest the engineers look closely at the affected .xlt file and upgrade/rewrite it to ensure compatibility with the current O365 version.

Level 1

Re: Export to Excel Failure

RoseMarjoireA,

 

The problem persists even from the sample file.

 

Downgrading Office 365, nor using an older version of Excel, is possible in my environment at this time.  Is there another solution?

Moderator

Re: Export to Excel Failure

Thank you for sharing the results after following the steps shared by my colleague, @DJChupa13.

 

Since you're still unable to export your report successfully, I'd recommend contacting our Customer Care Support. They can pull up and look into your account, securely. With their tools, someone can help you export your report and create a case ID or ticket if needed to do so.

 

Thus said, here's how you can contact our dedicated support:

  1. Go to Help.
  2. Select QuickBooks Desktop Help.
  3. Click Contact us.

Know that you can always visit our Help Articles page for QuickBooks Desktop in case you need some tips and related articles for your future tasks.
 
If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.

Need to get in touch?

Contact us