Skip to main content
W
williamghenry
June 3, 2019
Question

Unable to export Reports to Excel

  • June 3, 2019
  • 2 replies
  • 0 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

2 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
June 3, 2019

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

C
catheoch
December 6, 2019

Hello,

 

I too am having the same issue of not being able to explort to excel (other than as a CSV file)

I am using QB Desktop 2016  and have office 64-bit installed.

I do not wish/cannot switch to office 32-bit as this creates other isses (with other programs)

I have another installation of quickbooks on another pc, again with 64-bit office which CAN export to excel without issues. The conclusion being that this is NOT the core problem.

 

I have spent countless hours looking into this and it is clear that this is an issue for MANY people and I find it unthinkable that there is no specific and clear solution to this problem!

Switching to office 32-bit cannot possibly be a realistic solution as going forward, all computers will be running ONLY 64-bit.

 

Please come back with a solution that will help YOUR CLIENTS solve this issue as it is extremely frustrating.

Terms & ConditionsAccessibility statement