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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×