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

Schedule PowerPivot Data Refresh

How to: View PowerPivot Data Refresh History