Hi,

While connecting to the Cube through MS-Excel, you should give the Full address of the server, in the Server Name Text Box. eg:<Machine Name>\<Instance Name>,

then select the Use Windows Authentication...