Refreshing Excel File in PowerPivot from SharePoint
User Rating: / 0
Written by Teo Lachev   
Monday, 12 August 2013 19:25

A couple of SharePoint-related questions from students taking my PowerPivot class that are worth sharing.

Question: Can I import data from and auto-refresh an Excel file deployed to a SharePoint library in PowerPivot?

Answer: Yes, if you use WebDAV and specify the UNC path to the file. WebDAV requires the Windows Server Desktop Experience feature to be installed and the WebClient service to be started:




XL Cubed