locked
Excel Pivot table is not updating from the sharepoint list in MOSS 2007 RRS feed

  • Question

  • <p></p><p>Done the below steps:</p><p>1. Created sharepoint custom list<br />2. generated excel pivot table from the above created list<br />3. set the connection proerties of the excel to default windows auth and published the excel file into sharepoint document library</p><p>4. created connection file(.odc) and uploaded into sharepoint data coneection lib<br />&nbsp;&nbsp; generated .odc file from excel file-&gt;Data tab-&gt;Connections-&gt;Properties-&gt;Defination-&gt;Export Connection file.</p><p>under Excel Services Settings below changes are done<br />1.&nbsp; Edit Excel Services settings<br />&nbsp; File Access Method&nbsp; : Impersonation<br />&nbsp; External Data : Unattended Service Account (configured)</p><p>2. added document lib path under the trusted file locations<br />3. added dcl path under the Trusted data connection library.</p>
    Sunday, August 19, 2012 8:57 PM