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?
W
williamghenry
June 3, 2019
Question

Unable to export Reports to Excel

  • June 3, 2019
  • 17 replies
  • 22 views

Hello,

I have a serious problem with Quickbooks. I have contacted Quickbooks Support and they have been unable to help me.

I use QuickbooksDesktop Pro 2019 updated. I cannot export reports to excel. All the fields are greyed out apart from Export to CSV.

I have used this facility for some years now without error I upgraded to Quickbooks 2019 and installed the Updates and Export to Excel has always worked up until a few days ago

I was told by support to uninstall Quickbooks and Office 365 which I have used for some time now. I have done this and reinstalled Office 365 first.

This has not worked I believe their is a fault with quickbooks not syncing with excel but I cannot get this facility to work It is most annoying because all my reports have been exported to excel.

Thank you

Can anyone help please?

Thank you

William Henry

17 replies

E
EdwardR
June 3, 2019

Hi William,

 

Thanks for sending us your question on Community.

 

We can certainly help with trying your QuickBooks exporting reports the way you like. Can I please confirm the version of Office 365 which you are using and if this locally installed or the online version?

 

Could you also send a screenshot of the account of the export to excel page when selecting on the export.

 

Thanks,

W
williamghenryAuthor
June 3, 2019

Hello,

Thank you very much for replying to my question about being unable to Export Reports to Excel.

The problem has now been solved.

I uninstalled my 64 bit version of Microsoft Office 365 and I reinstalled the 32 bit version

All the options to export reports into Excel are available.

Thank you very much for your help.

Kind regards,

William Henry

G
GeorgiaC
Level 13
June 3, 2019

Thanks for getting back to us William, we're happy to know that's working for you now :)

M
MLC1
January 6, 2020

Hi MLC1

 

If you want Excel to work with QuickBooks 2016 you will have to have a locally installed version of office. The alternative is to upgrade to the 2019/20 version of QuickBooks which is compatible with office 365.


Ok, now I am using Quick Books 2019 Pro and the Export to Excel item is still greyed out and unavailable.  My version of Office 365 shows an Active Application Add-in of QB Excel 2007 Report Updater_64bit.dll.  

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