Refresh the data or data model for a Power View sheet

You can choose to refresh the data for a Power View sheet or view. You have no choice about refreshing the data model; if it changes, you get a message that Power View needs to refresh the sheet or view.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

When you refresh the data, you can choose to refresh it for one Power View sheet in a workbook (Refresh) or for the entire workbook (Refresh All).

Refreshing the data goes all the way back through the data model on which the Power View sheet is based, back to the data source to get the latest data. So refreshing the data in Power View also refreshes the data in the data model, whether it’s the internal Data Model in the Excel workbook or an external data model the Power View sheet is connected to.

Power View Refresh button
Power View Refresh and Refresh All

Top of Page

See Also

Power View: Explore, visualize, and present your data

Power View and Power Pivot videos

Tutorial: PivotTable data analysis using a Data Model in Excel 2013

Top of Page

Applies To: Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language