Manage PowerPivot Data Refresh
After you create a workbook that contains PowerPivot data, you might want to periodically refresh the data by rerunning a query or command to get updated information from the sources you used originally to create the workbook. This process is called data refresh, and you can refresh data on demand in PowerPivot for Excel, or as a scheduled operation that runs as an Analysis Services process on an application server in a SharePoint farm.
Information about PowerPivot data refresh can be found in the following topics:
PowerPivot Data Refresh Overview
Enable and Configure PowerPivot Data Refresh
Configure and Use Stored Credentials for PowerPivot Data Refresh
Configure and Use the PowerPivot Unattended Data Refresh Account