I have enabled the OLAP through the Web using Integrated Windows Authentication.I create a excel file locall
and see the changes in the data as I change the priviliges on the Analysis Server.I have turned the option to refresh my WorkBook everytime its opened.Everything is fine on the server
When I try to access the same excel through another Client using http://servername/vd/xyz.xls .Please note I am using hard coded authentications (for testing) in the connection string
I do not see the data getting refreshed.It shows the same set of data that it was created with but when I try to do it on the server it was created the data gets refreshed.