Users are accessing OLAP (MS Analysis Services 2000) over HTTP from excel.
They are entering there NT login and password and accessing the data. We are
facing a problem with a user having Windows XP OS and Office 2003. When first
time we make connection from Excel, login popup appears. We have stored login
and password by selecting remember password option. We create a report in
excel. Now when we copy same pivot to other sheet the problem starts. Login
screen continously keeps on coming up and then excel gets hanged. Had to
delete task using task manager. Any help on this problem will be appreciated.
Thanks