Check to make sure that the xla add-in is being loaded in excel. I had to manually add this on a couple of occasions with 2022.

Thank you for responding Terry. Silly question, but where can I get the .xla add-in so that I can add it in?

You can find it under GL69A

Thank you so much! 

Did this work for you? I have had similar issues, but ended up going back to 32-Bit.

We had the same problem with Sage 300 2022 workstation setup with Office 2091 Pro on a RDP server. We tried the following:

1.Uninstall Office & Sage ws, scrub Office and reinstall. Didn't help.

Sage Australia support suggested:

2. the usual Excel macro and addin settings suggested elsewhere. Didn't help.

3. Install PU1 before PU2. Should not be necessary. Didn't help. (If PU2 requires PU1 installed first, why doesn't the Update Notice say so?)

4. After all that, Sage finally said FR on RDP server needs full Sage install instead of workstation. We never needed that before. If true, why isn't that documented?.  We didn't bother trying it due to the cost and maintenance risks and lack of guaranteed result, and just installed Sage ws and office 32-bit on a separate Windows 10 VM for the FR user instead.

It is documented and has been since v2019.  As of February 2019 Sage updated the Compatibility guide to include the following:

"The full Sage 300 System Manager and programs need to be installed on the Citrix/Terminal Servers"