UserForm_Initialize - Web Browser Excel Fail

Error message: UserForm_Initialize - Method 'RegisterAsBrowser' of object 'IWebBrowser2' failed. 

Excel Web Browser Object Error when using Cube

Description:

When attempting to use a Diligent connected Excel cube file, the user will unexpectedly encounter the above error or one like it.

Solution:

1. In Excel, go to File > Options > Trust Center > Macros and fully enable Macros. Quit and restart Excel. See if that works. 
2. Run the file through the cube updater in Diligent under the Analysis tab. See if that works.
3. Force your system to always use Internet Explorer (rather than Edge) for Diligent usage by following these steps: https://support.ebmsoftware.com/hc/en-us/articles/4405571848589-Frozen-Processing-Diligent-in-Browser