PowerPivot Window: Linked Tables Tab

This section provides Help on the Linked Tables tab in the PowerPivot window, including the dialog boxes that are available from this tab. For an overview of the user interface and instructions on how to open the PowerPivot window, see Take a Tour of the PowerPivot UI.

The Linked Tables tab is available on the PowerPivot ribbon under Table Tools, when you select a PowerPivot table that is linked to an Excel table. For more information about what linked tables are and how you can use them to refine your data, see Add Data by Using Excel Linked Tables.

PowerPivot window Linked Tables tab with callouts

Note

In Windows Vista and Windows 7, features in the PowerPivot window are available on a ribbon, which is discussed in this section. In Windows XP, features are available from a set of menus. If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see The PowerPivot UI in Windows XP.

Options on the Linked Tables Tab

The Linked Tables tab contains the following options.

  • Update All. Click to update all the PowerPivot tables that are linked to tables in Excel.

  • Update Selected. Click to update only the currently selected PowerPivot table. Note that the table must be linked to a table in Excel to be updated; these options do not apply to tables from other sources.

  • Excel Table. Displays the names of all tables that are available in the Excel workbook. You can type a name to go to that table, if the name is a valid table within the current Excel workbook.

  • Go to Excel Table. Click to switch to the Excel workbook and view the table.

  • Update Mode. Click to set the update mode for linked tables to either Automatic or Manual. This affects how changes in an Excel table affect the linked table in the PowerPivot window.

Dialog Boxes

The following topics provide Help for the dialog boxes that are available from the Linked Tables tab.