Hi,

I want to access analysis server from excel pivottable. My analysis server is in different domain. the user that I try to login is from this domain, and this user is the olap administrator, also the local admin of the server. But when I try to connect I meet with this error: "Unable to open the connection. the operation requested failed due to the security problems - the user could not be authenticated"

Does anybody have sth. to recommend? thanks....