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.

It was straightforward to get 32-bit apps to talk to 64-bit Office.

This post hasn't aged well, my comments are now wrong.

I can confirm that on 2022 PU4, you can run 64-bit office, not only with Financial Reporter, but with custom VBA programming.  We upgraded one of our big clients last week, and they're happy that 64-bit Excel finally runs.

The only issue I had was with VBA forms that had a Fieldedit control and a Datasource.  The Datasource control is not currently available in 64-bit.  The KISS solution for my client was to abandon the pretty finder and use a simple text field for them to type in the vendor number.

This post hasn't aged well, my comments are now wrong.

I can confirm that on 2022 PU4, you can run 64-bit office, not only with Financial Reporter, but with custom VBA programming.  We upgraded one of our big clients last week, and they're happy that 64-bit Excel finally runs.

The only issue I had was with VBA forms that had a Fieldedit control and a Datasource.  The Datasource control is not currently available in 64-bit.  The KISS solution for my client was to abandon the pretty finder and use a simple text field for them to type in the vendor number.

I will have a look at that, maybe tomorrow. 

The a4wDataSource control builds x64, but I am unsure if it has breaking dependencies.

It's up to Product Ownership to have it included in the PU. I have brought this to their attention.