autoupdate of excel in PowerPivot

Question

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?

Answer 1

Hi,

If you are using Excel 2013 you can automate the refresh with a macro.

PowerPivot Nuggets - Part 18 - Automate PowerPivot Refresh with Excel 2013
http://www.vandeputte.org/2012/07/powerpivot-nuggets-part-18-automate.html

Kind regards,

Frederik

Answer 2

Hi ankit28287,

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

Regards,
Bin Long

---

Bin Long

TechNet Community Support