Unfortunately 64 bit Office is not currently supported for the send to Excel functionality. It is possible to use the export to Excel options for reports and to send emails via 64 bit Outlook though.

Hope that helps 

Hi

I had the desktop installation of office 2019 64 bit before. the send to excel button worked then.

i understand that Excel Integrated reporting does not work for the 64bit but the send to excel button did work. its just not working any more now i have office365 apps for business version 

The option to send to Excel from a ledger view has only ever worked with 32 bit versions of Office, but the send to Excel option from the report browser or with Report Designer should work just fine with 64 bit.

When you say that it is not working do you get some kind of error message?

If i am in a supplier / customer window or nominal window there is a button along the top called Send to Excel. that has always worked for me even on 64bit 2019 office. 

If i click it now it says Failed to connect to excel - if i click ok it goes through the motions of looking like it is copying to excel like it used to but the excel file does not appear 

That button can never have worked with a 64 bit version of Excel as it uses COM to interop with Excel. Sage 50 Accounts is a 32 bit process so can only create 32 bit COM objects. It is impossible for it to create a 64 bit one.

The message you get currently saying that the app has failed to connect is exactly what I'd expect if you have a 64 bit version of Office installed. The application is simply unable to communicate with Excel via COM.

The only workaround would be to use the send to Excel option from the report browser or Report Designer as this does not use COM and instead generates an Excel file directly and simply launches that.

That button can never have worked with a 64 bit version of Excel as it uses COM to interop with Excel. Sage 50 Accounts is a 32 bit process so can only create 32 bit COM objects. It is impossible for it to create a 64 bit one.

The message you get currently saying that the app has failed to connect is exactly what I'd expect if you have a 64 bit version of Office installed. The application is simply unable to communicate with Excel via COM.

The only workaround would be to use the send to Excel option from the report browser or Report Designer as this does not use COM and instead generates an Excel file directly and simply launches that.

Ok but it did use to work. 

I found this page on sage eventually that said that 64bit would work with the send to excel button 

What is the compatibility of my software with Microsoft Office? (sage.com)

 NOTE: A warning symbol ️in the chart means the version is partially compatible and can send information to Excel and use ODBC integration. If these versions are 64-bit, you must install the 64-bit ODBC driver.  

i tried to install the 64 bit driver but it said it was already installed. 

As i have a office 365 licence on a desktop based install 64bit of office i would expect it should work as per the page link above 

64 bit Office will definitely not work with that button. The COM restriction means it is simply not possible for Accounts to create a 64 bit COM object. The only way it can work is with a 32 bit version of Office. I'll feed back on the article as it is not accurate by the sounds of it.

As it stands though the only way to get that button to work is to uninstall the 64 bit version of Office and install a 32 bit version. If this is not possible/desirable then it would only leave you with the workarounds already mentioned I'm afraid. 

Ok, about time Sage caught up and started working with 64bit :-(

Darron Cockram 

We're been having the same problem since we upgraded the M365 Office software on our remote desktop servers to 64-bit.

You mention that the 64-bit Office will definitely not work with the "Send to Excel" button, however it does actually work on two our our RDS servers. It is just one of them it doesn't work on.

The Sage support artlces also advise that the Send to Excel functionality is compatible with 64-bit Office.