How to Open a Pivot Table in Excel: View and Edit It

Charts & pivot tables · Updated November 21, 2026

To open an existing PivotTable in Excel, open the workbook, select the worksheet that contains it, then click any cell inside the PivotTable. Excel activates the contextual PivotTable tab; choose PivotTable Analyze > Field List to view or change its fields. You can also click within the table to inspect its values or use its filter controls. The steps below apply to Excel for Microsoft 365 on Windows.

What You’ll Need

  • An Excel workbook containing a PivotTable. A PivotTable is an interactive summary of data; it may be on a different worksheet from the original source data.
  • Permission to open and, if needed, edit the workbook. If the file is password-protected or marked read-only, you may need the password or an editable copy to make changes.
  • Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac and Excel for the web have similar features, though tab names and available commands can differ slightly.

Step-by-Step

  1. Open the workbook. In Excel, choose File > Open > Browse, locate the workbook, select it, and choose Open. If it is in OneDrive or SharePoint, you can open it from the relevant location in Excel’s Open screen. If you already have the workbook open, continue to the next step. If Excel displays a Protected View banner for a file you trust, review the source before choosing Enable Editing.
  2. Find the worksheet containing the PivotTable. Look at the sheet tabs along the bottom of the workbook and select the likely sheet. The PivotTable may be on a sheet named Summary, Report, or something specific to the workbook, but its name is not guaranteed. If you do not know which sheet contains it, click the sheet tabs one at a time and look for a structured summary with row or column labels and filter arrows. Use the workbook’s navigation or search features if it has many sheets.
  3. Click a cell inside the PivotTable. Select a label, number, or other cell that visibly belongs to the summary. Excel should add a contextual PivotTable Analyze tab to the ribbon, and often a Design tab as well. The contextual tabs only appear while a PivotTable cell is selected. Clicking a nearby blank cell, a chart, or the source data does not activate them. If unsure, click a different cell within the outlined summary.
  4. Show the field list if it is hidden. With a PivotTable cell selected, choose PivotTable Analyze > Field List. The field list normally opens on the right side of the Excel window. It lists the available fields from the PivotTable’s source and shows which fields are currently arranged in the report. If the list is already open, the same command can hide it; click it again to bring it back.
  5. Read the layout in the field list. The lower part of the pane has areas for Filters, Columns, Rows, and Values. These areas show how the report is organized: row fields create labels down the table, column fields spread categories across it, value fields are summarized, and report filters can limit what is displayed. The precise position or arrangement of the pane can vary with window size, but the field names and areas serve the same purpose.
  6. Inspect or adjust the PivotTable. To filter what you see, use the drop-down arrow beside a row or column label in the PivotTable, select or clear items, and apply the choice. To change its layout, drag a field between the field-list areas. For example, moving a category from Rows to Columns rearranges the summary; moving a numeric field into Values adds a calculation. You can also use the check box beside a field to add it, though Excel chooses its initial area based on the field type and existing layout. Make one change at a time and check the result.
  7. Refresh if the source data has changed. If you expect newer source records to appear, click inside the PivotTable and choose PivotTable Analyze > Refresh. To refresh all PivotTables in the open workbook, choose Data > Refresh All. Refreshing updates the report from its existing source; it does not automatically include data added outside the source range in every workbook. Check that the source range includes the new records if they are missing.
  8. Close the pane or save your changes. Click Field List again to close its pane, or click another part of the sheet. If you changed the layout, filter, or other workbook content and want to keep the changes, press Ctrl+S on Windows. If you only opened the file to view it, you do not need to save. When a file is shared, check whether Excel indicates that it is read-only or that your changes need to be saved as a separate copy.

On Mac: The same basic method applies: open the workbook and click inside the PivotTable. Excel displays contextual PivotTable controls, but their labels and ribbon arrangement can differ from Windows. Look for the PivotTable analysis or field-list command in the contextual ribbon. The Windows shortcut Ctrl+S is usually Command+S on Mac. In Excel for the web: open the workbook in the browser and select a cell in the PivotTable; use the PivotTable tab or its available ribbon controls to access the field list and report options. Some advanced PivotTable features may require opening the workbook in the desktop app.

Common Mistakes

  • Clicking beside the PivotTable. The contextual tab appears only when the active cell is part of the PivotTable. Select a visible label or value inside its boundaries, not a nearby blank cell.
  • Confusing the source data with the PivotTable. Clicking the original data range does not open the PivotTable controls. Find the sheet containing the summarized report first.
  • Assuming the field list is the PivotTable itself. The list is a control pane for arranging report fields. The actual summary remains on the worksheet; closing the pane does not delete the report.
  • Changing the layout before checking the current one. Dragging a field into a different area can substantially rearrange the report. Note the existing arrangement or save a copy before experimenting with an important workbook.
  • Expecting Refresh to fix every missing item. Refresh updates the existing PivotTable source. If newly added rows lie outside a fixed source range, the report may not include them until that range is expanded or the source is converted to an Excel table.
  • Clicking a PivotChart and looking for the PivotTable tab. A PivotChart has its own contextual chart tabs. Select a cell in the underlying PivotTable to open its PivotTable controls.

Tips

  • Use the table’s visual boundaries. PivotTables often have a header row, grouped labels, and a consistent block of summarized values. Clicking a cell in that block is the quickest way to activate the right controls.
  • Resize Excel if the field list is hard to see. Maximize the window or widen it so the pane and its four layout areas are visible. You can also drag the pane’s edge where supported to give it more room.
  • Keep viewing separate from editing. Selecting a cell and opening the field list are safe ways to inspect a report. Dragging fields, changing filters, or refreshing can alter what the workbook displays, so save only if you intend to keep those changes.
  • Use Excel’s sheet navigation for large workbooks. If there are too many tabs to scan, use the sheet navigation arrows near the lower-left corner to move through tabs, or right-click those arrows to display a list of sheets in supported desktop versions.
  • Know what double-clicking a value does. In many PivotTables, double-clicking a summarized value opens a new worksheet with the underlying records used for that number. It does not open the field list, and the detail sheet is a drill-down copy rather than the PivotTable’s source-management screen.
  • Protect the original report when exploring. If you need to test a different arrangement, use File > Save As to create a working copy first. This is especially helpful when the workbook is shared or used for a recurring report.

Troubleshooting

The PivotTable Analyze tab does not appear: First click a cell that is definitely inside the PivotTable, such as a row label or displayed total. If you selected a chart, blank area, or source-data cell, the relevant PivotTable tab will not appear. If the table is very small or its boundaries are unclear, click a visible value and check whether the contextual ribbon changes. On Mac or in Excel for the web, the contextual tab may have a different label or location.

Field List is missing or will not open: Select a PivotTable cell before looking for PivotTable Analyze > Field List. The command may be on a contextual tab that is hidden until the selection is correct. If the workbook window is narrow, maximize it or inspect the ribbon for collapsed commands. In Excel for the web, use the available PivotTable tab controls; if the field-list option is unavailable for that workbook, open it in the desktop app.

You cannot find the PivotTable: Check other worksheet tabs; the source-data sheet and report sheet are often separate. Look for a block of summarized labels and values rather than assuming the PivotTable is named or formatted in a particular way. If the workbook has many sheets, use its sheet navigation controls. If you only have a PDF, screenshot, or exported values rather than the Excel workbook, there may be no interactive PivotTable to open.

The workbook opens as read-only or in Protected View: Read-only status may let you inspect the PivotTable but prevent saving edits. If the file is from a trusted source, follow Excel’s prompts to enable editing or use File > Save As to make an editable copy, if permitted. Do not enable editing for an unexpected file unless you trust its origin. A workbook protected by a password or organizational policy may require its owner or administrator to grant access.

The PivotTable looks out of date or lacks new rows: Click inside it and choose PivotTable Analyze > Refresh. If the expected records still do not appear, the source range may not cover them, the source may be an external connection, or filters may be excluding them. Check the filters and ask the workbook owner about the data source if you cannot change it. Refreshing does not guarantee that a connection can update when you are offline or lack access.

Frequently Asked Questions

How do I open the PivotTable Field List in Excel?
Click inside the PivotTable, then choose PivotTable Analyze > Field List on the Windows ribbon. If the command seems missing, confirm that a PivotTable cell—not a nearby cell—is selected.

Can I open a PivotTable without changing it?
Yes. Opening the workbook, selecting the PivotTable, and viewing the field list do not by themselves change its layout. Avoid dragging fields, changing filters, or refreshing if you want to leave the report as it is; close without saving if you made accidental changes.

How can I tell whether a summary is a real PivotTable?
Click inside it. If Excel displays contextual PivotTable controls such as PivotTable Analyze, it is an interactive PivotTable. A copied or manually formatted summary may look similar but will not activate those controls.

Can I open a PivotTable in Excel for the web?
Usually, you can open the workbook, select the PivotTable, and use the PivotTable controls available in the browser. The command labels and supported editing features can differ, so use the desktop app if an option you need is unavailable.

What happens if I double-click a number in a PivotTable?
Excel may create a new worksheet listing the source records behind that summarized value. This is called showing details. It is different from opening the Field List, and the command may be disabled by workbook settings or data-source limitations.

Does opening a PivotTable update its numbers automatically?
Not necessarily. A PivotTable may need a refresh after its source changes. Use PivotTable Analyze > Refresh and verify that the source range and filters include the data you expect.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.