Monday, August 13, 2012 5:30 AM
i am fetching data from excel file(.xls),which is in sharepoint. but when excel file in sharepoint get updated powerpivot related sheet donot get update after pressing refresh button in powerpivot.
i am also not able to create macro to auto update for same.is there any way to resolve both these problems?
- Edited by ankit28287 Monday, August 13, 2012 5:34 AM
Monday, August 13, 2012 1:25 PM
If you are using Excel 2013 you can automate the refresh with a macro.
PowerPivot Nuggets - Part 18 - Automate PowerPivot Refresh with Excel 2013
Thursday, August 16, 2012 5:18 AMModerator
The Excel refresh and the PowerPivot refresh are distinct operations. PowerPivot data refresh is unrelated to the Excel data refresh feature and we cannot refresh PowerPivot data by using the standard data refresh capability in Excel.
For more information, I recommend you refer to the following articles:
PowerPivot Data Refresh Overview: http://technet.microsoft.com/en-us/library/ee210690(v=sql.105).aspx
Everything You Always Wanted to Know About PowerPivot Data Refresh but Were Afraid to Ask: http://technet.microsoft.com/en-us/library/ff976569.aspx
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, August 21, 2012 1:33 AM