I have Essbase version 11.1.2.1.00.21.
We have Smart View version 11.1.2.5.720
If a spreadsheet was connected to a shared or private connection previously, it will connect with no issues.
However, if I open a new spreadsheet and connect (either through Shared or Private connections) it will ask me to log in, then when I click on the drop down box to Oracle Essbase it closes Excel completely. It does not seem to matter what version of office the person is using. However it is not happening to every user and I cannot figure out why.
It just started doing this today. The only thing that changed today is that we had to physically move our server from one location to another. I have started all the services that i know of on the server.
If anyone can help.
Thanks! 