<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 /> generated .odc file from excel file->Data tab->Connections->Properties->Defination->Export
Connection file.</p><p>under Excel Services Settings below changes are done<br />1. Edit Excel Services settings<br /> File Access Method : Impersonation<br /> 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>
