Important This feature isn’t available in Office on a Windows RT PC. Power View and Power Pivot are available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013. Read Excel 2010 workbooks with Power Pivot don't work in some versions of Excel 2013. Want to see what version of Office you’re using?
Excel 2013 RT is missing a few features that Excel 2013 provides. If you’re sharing workbooks created in Excel 2013 on Windows Vista, Windows 7, or Windows 8, and the workbooks contain Power View sheets or a Data Model, you might run into application compatibility issues. Here are details about what’s available and unavailable, and the errors you’ll encounter.
On the other hand, PivotTables are available in Excel 2013 RT. Thus, you can connect to an Analysis Services data source, either multi-dimensional or tabular, and create a PivotTable to analyze external data.
Read about PivotTables in Excel 2013 RT connect to Analysis Services data sources.
Power View sheets
Power View sheets are an interactive data visualization experience that you can add to an Excel 2013 workbook. If you open a workbook containing a Power View sheet in Excel 2013 RT, the Power View sheet still shows up in the workbook, but instead of interactive data it shows a placeholder image.
Although Power View is not available in Excel 2013 RT, you can use your Windows RT PC to connect to an Excel 2013 workbook on Office 365. There you can view and interact with the data visualizations in Power View sheets. You can’t edit Power View sheets in Excel 2013 on Office 365.
More about Power View in Office 365.
The Data Model is the embedded, related tabular data in Excel that you use with PivotTables, PivotCharts, and Power View reports. The Data Model is created in the background when you import multiple related tables from a relational data source, or when you create relationships among individual tables in a workbook. On Office RT, data models are not supported.
If you filter data that originates from an embedded data model, you’ll see these errors:
“Unsupported Features: This file contains unsupported features that may not work as expected. Learn more.”
“We cannot run one or more of the following features in this version of Office:
- VBA Project
- ActiveX Controls”
Using Windows RT PC, you can connect to a workbook data model on Office 365. PivotTables and PivotCharts can’t be edited, but are otherwise fully operational. You can slice, filter, and change the contents of a Field List for ad hoc data analysis.
More about data models in Excel 2013.
Power Pivot Add-in
In Excel 2013, the Power Pivot add-in is used for data model management, including viewing its contents and augmenting it with KPIs, hierarchies, and calculations. The Power Pivot add-in for Excel 2013 is available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013 on Windows Vista, Windows 7, and Windows 8.
More about Power Pivot in Excel 2013.