Scenario:1 (In my local machine: Sharepoint link can be accessed without passing the userid and password)
1. Click on actions in sharepoint site and export it to excel. Save the excel in the required location.
2. Go to Data tab of excel and do the following
Connections --> Properties --> check: Enable background refresh and Refresh data when opening the file
3. Save the file
After this I have created one macro which opens up the above excel as we have enabled the above properties in Data tab it will automatically fetch the latest data from the sharepoint link.
Scenario:2 (In server machine: Sharepoint link can only be accessed by passing the userid and password)
Here I am not able to do step:2(Mentioned). May be it is asking for the userid and password to access the sharepoint link. I think the problem here might be because of the security.
So any idea what could be the possible reasons for been able to achieve the same in scenario:2. Also would like to know what need to be done for the scenario:2 so that it can achieved same like scenario:1.
Hope someone can helpme out on this!
Have already refered this in the following post but unable to find the solution yet :-(