13 Replies Latest reply: Mar 8, 2013 1:27 AM by Yojas Samarth RSS

    Loading data from sharepoint list work in local but couldn't make it work in the development server

    Rikab Kothari

      Hi All

       

      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 :-(

       

      http://community.qlik.com/message/255028#255028

      http://community.qlik.com/message/254657#254657

      http://community.qlik.com/message/254552#254552

      http://community.qlik.com/message/253928#253928

      http://community.qlik.com/message/253970#253970

      http://community.qlik.com/message/253964#253964

      http://community.qlik.com/message/253963#253963

      http://community.qlik.com/message/253962#253962

      http://community.qlik.com/message/253960#253960

      http://community.qlik.com/message/253958#253958

      http://community.qlik.com/message/253956#253956

      http://community.qlik.com/message/253955#253955

      http://community.qlik.com/message/253952#253952

      http://community.qlik.com/message/253951#253951

      http://community.qlik.com/message/252820#252820

      http://community.qlik.com/message/253949#253949

      http://community.qlik.com/message/253947#253947

      http://community.qlik.com/message/253946#253946

      http://community.qlik.com/message/253929#253929

      http://community.qlik.com/message/253927#253927

      http://community.qlik.com/message/253926#253926

      http://community.qlik.com/message/252325#252325

      http://community.qlik.com/message/252145#252145

      http://community.qlik.com/message/252143#252143

      http://community.qlik.com/message/252142#252142

      http://community.qlik.com/message/251924#251924

      http://community.qlik.com/message/251875#251875

      http://community.qlik.com/message/251862#251862

      http://community.qlik.com/message/251817#251817

      http://community.qlik.com/message/249903#249903

      http://community.qlik.com/message/249902#249902

      http://community.qlik.com/message/249900#249900

      http://community.qlik.com/message/249899#249899

      http://community.qlik.com/message/249896#249896

       

      Thanks

      qvforum