Office 64-bit Integration & Support?

Forget about it, Sage will always be a 32-bit product.  And 64-bit Office doesn't get you anything, it's not faster or safer.

I was afraid you'd say that, although not surprised.  As a systems admin, the default configuration is always the easiest to support and lately that has been 64-bit Windows + 64-bit Office. I'd just as soon maintain one base image with Windows/Office 64-bit.  

On a side note, we have several 32-bit apps that seem to integrate fine with 64-bit Office.  Adobe Acrobat, Mitel and Zoom come to mind.  Tight Office integration between 32-bit apps and 64-bit Office.  Seems doable with 32-bit Sage as well.

My understanding is the later versions of S300 works fine with x64 of Office and it comes down to more a matching of system privilege's between the two systems. Like you cant have S300 running with admin privilege's and office not or vice versa. Or even running as Admin in either may cause Office to spit the dummy. 

Sage 300 is a 32 bit application, it will never talk to Office 64 bit. Not unless Sage 300 is rewritten in 64 bit, but that is not going to happen. With that said.... you can export/import data no matter which Office 32/64 bit you have installed, you just cannot run FR and some other integrations that require both applications to be 32 bit.

The Sage 300 2022 (69) compatibility guide (last revised August 23, 2021) shows "Microsoft Excel 2016 (32 or 64 bit), or 2019 (32 or 64 bit) is required on each workstation running the GL Financial Reporter." and the release notes also confirm this (thanks Ettienne Schwagele Acumen).

Erzsi_I, regarding Office 365, can you please confirm that Excel 64-bit (import export, Financial Reporter) and Outlook 32-bit  (emailing via MAPI) are supported by Sage in 69?

Office 365 is supported.
FR Support for Excel 64bit was announced with Sage 2022, see the what's new doc. Any prior Sage version did not support Excel 64bit in FR.
help.sage300.com/.../index.htm

64 bit office doesn't run faster, it's not an upgrade, it's a side-grade.  You only need it if you use Excel spreadsheets over 2 Gb, which eliminates 99% of users.

Extract from the Sage 2022 release notes:

Sage 300 desktop screens improvements
This product update includes the following new features and improvements in Sage 300 classic desktop screens:

Financial Reporter now supports Microsoft Excel 64-bit.

Microsoft 365 integration with Sage 300
The Sage Contact app (for viewing and managing Sage 300 customer information within Microsoft Outlook) is no longer supported.

RE Excel 64-bit, PIBKAC - thanks Ettienne.
RE Office 365, I don't see anything say it is supported - will raise to Erzsi_I in my original reply (unless PIBKAC of course).
Thanks!

Hi Aslan, ran your question:

aslan.kanzas said:

please confirm that Excel 64-bit (import export, Financial Reporter) and Outlook 32-bit  (emailing via MAPI) are supported by Sage in 69?

by the Sage 300 support team, who advised that MS Office doesn't have an option to mix and match 32bit apps with 64bit versions of apps. 

The team also recently posted a blog for Sage 300 version 2022 (6.9) titled After upgrading Microsoft Excel to 64bit, Financial Reporter returns error with Excel Add-in. which gives steps on how to ensure a proper 64bit install of Microsoft Office. Hope this helps!