Please refer the screenshot attached. With the ActiveX settings enabled appropriately, the issue is now Intermittent. Also sometimes simple update through excel is also not working. Please let me know if any other changes are also required.
I reached out to my SMEs and they believe that this will require more in-depth troubleshooting and a potential screenshare. They request that you open an SR. Please when you've opened your SR, come back here and reply with the SR ID so that we may connect this post to the SR to help with troubleshooting.