2016 Interface

microsoft excel docs

Manage - Displays the separate Power Pivot application window allowing you to load and prepare data or continue working on data already added to this workbook.
Measures - Drop-Down. The drop-down contains the commands: New Measure (previously New Calculated Field), Manage Measures (previously called Calculated Fields)
KPIs - Drop-Down. The drop-down contains the commands: New KPI, Manage KPIs.
Add to Data Model - Create a linked table by adding this Excel table to the Data Model. Linked tables are a live link between the table in Excel and the table in the Data Model, so any updates to the table in Excel automatically update the data in the model. If this table is already in the data model, this action adds a copy to the data model.
Detect - Automatically detect and create relationships between tables used on the selected Pivot Table.
Settings - Displays the "PowerPivot Settings" dialog box. Define settings for your Power Pivot environment and specify language options.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext