Error message: UserForm_Initialize - Method 'RegisterAsBrowser' of object 'IWebBrowser2' failed.
Excel Web Browser Object Error when using Cube
Description:
When attempting to use a Catalyst connected Excel cube file, the user will unexpectedly encounter the above error or one like it.
Solution:
- In Excel, go to File > Options > Trust Center > Macros and fully enable Macros. Quit and restart Excel. See if that works.
- Run the file through the cube updater in Catalyst under the Analysis tab. See if that works.
- Force your system to always use Internet Explorer (rather than Edge) for Catalyst usage by following these steps: https://support.ebmsoftware.com/hc/en-us/articles/4405571848589-Frozen-Processing-Catalyst-in-Browser