I have developed some Excel files with hyperion smart view vba functions. In this file I have some retrieves on which I have configured the connection to the desired instances.
When the user opens the file, the pop up connection appears where he/she has to log in. However, when the user logs in this error appears :
"Unable to connect to provider. The server name could not be resolved"
This error actually is not blocking since when the user closes it and try to reconnect it works. But I am wondering where this might come from and I could not find anything on the internet.
FYI, all of my connections are correctly defined since I managed to refresh the retrieves eventually. Any idea ?