Excel Find Pivot Table Names: Where to Look

Charts & pivot tables · Updated November 19, 2026

To find a PivotTable’s name in Excel for Microsoft 365 on Windows, click any cell inside it, open PivotTable Analyze, and read the PivotTable Name box in the PivotTable group. That box also lets you rename the selected PivotTable; to find names throughout a workbook, use a short VBA listing macro or inspect each PivotTable in turn.

Where to find the selected PivotTable’s name

Excel displays PivotTable commands only when a PivotTable is selected. Click a cell within the report, then select the contextual PivotTable Analyze tab on the ribbon. In its PivotTable group, look for the text box labelled PivotTable Name. The value in the box is the selected report’s object name, such as PivotTable1 or SalesSummary.

If you do not see the contextual tab, first confirm that the active cell is inside the PivotTable rather than in a nearby blank cell or source-data range. You can also click a visible value or label in the report. In a narrow Excel window, ribbon groups may be compressed, so maximize the window or expand the relevant group to reveal the name box.

On Excel for Mac, select a cell inside the report and use the contextual PivotTable analysis tab; ribbon labels and layout can differ slightly from Windows. Excel for the web has a more compact ribbon, and some options vary by account and update. VBA macros, including the workbook-listing example below, cannot run in Excel for the web.

What a PivotTable name identifies

A PivotTable name identifies one PivotTable object in the workbook. It is useful when a workbook has several reports, when writing VBA that refers to a particular report, or when distinguishing similar summaries. Excel assigns names such as PivotTable1 and PivotTable2 when reports are created, but those automatic names do not describe what the reports show.

The name is not the same as a field caption such as “Region” or “Sum of Revenue,” and it is not the name of the source table or worksheet. For example, a report based on a table called Orders might be on a sheet called Summary and have a PivotTable name of RevenueByRegion. Those are three separate identifiers.

A PivotTable name is also not a defined name. Excel’s Name Manager, opened from Formulas > Name Manager, is for defined names and formulas; it is not the general inventory of PivotTables. Similarly, the Name Box beside the formula bar is mainly for cell references and defined names, not a dependable way to browse PivotTable object names.

Finding a particular PivotTable in a large workbook

The name box tells you the name of the report you have already selected. It does not provide a workbook-wide search that takes you directly to a PivotTable by name. If you know the name but not its location, first create an inventory of PivotTables and their worksheet locations. The VBA option below does this in one pass. Without a macro, you must visit the worksheets and click inside each report to read its name.

For manual searching, use the sheet tabs to visit likely summary sheets and click within each PivotTable. A worksheet can contain multiple PivotTables, so record both the name and the sheet as you go. A useful inventory might look like this:

  • Summary: RevenueByRegion
  • Products: UnitsByCategory
  • Monthly: OrdersByMonth

This pairing matters because the PivotTable name alone may not make its location obvious to a person reading your notes. If a sheet is hidden, unhide it through the sheet-tab context menu before trying the manual approach. A macro that loops through worksheets can also report PivotTables on hidden worksheets.

Renaming a PivotTable

To give a report a more descriptive name, select a cell inside it, go to PivotTable Analyze, click the PivotTable Name box, enter the new name, and press Enter. For example, changing PivotTable3 to OrdersByQuarter makes it easier to recognize in VBA or in a workbook inventory. Choose a concise name that describes the report rather than its current position on a sheet.

Excel does not treat this as a visible report heading. Renaming the object will not change the worksheet tab, the PivotTable’s row or column captions, or the source table. If readers need a title, add or edit a worksheet cell above the report as well. Keep the object name and visible title reasonably consistent so later users can connect them.

  • Use a distinct, descriptive name; Excel will not accept a name already used by another PivotTable in the workbook.
  • Prefer a simple name with letters, numbers, or underscores. Avoid spaces and punctuation that may cause problems when referring to the object in code.
  • After editing, press Enter and check that the name remains in the box. If Excel rejects it, try a shorter, simpler name that is not already in use.

Listing every PivotTable with VBA

When the workbook contains many reports, a macro can create a worksheet listing each PivotTable’s worksheet and name. In Excel for Microsoft 365 on Windows, press Alt+F11 to open the Visual Basic Editor, choose Insert > Module, and paste the code below into the module. Run ListPivotTableNames from the editor, or return to Excel and run it from Developer > Macros. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon.

The macro adds a new worksheet and writes one row per PivotTable. Its first column is the worksheet name and its second column is the PivotTable name. If there are none, it writes that result on the new sheet. Save a copy of the workbook before running a macro: VBA changes cannot be undone with Ctrl+Z. The macro may also be blocked if the workbook’s structure is protected.

Sub ListPivotTableNames()
    Dim sourceSheet As Worksheet
    Dim pivot As PivotTable
    Dim reportSheet As Worksheet
    Dim nextRow As Long
    Dim found As Boolean

    ' Add a worksheet for the inventory.
    Set reportSheet = ThisWorkbook.Worksheets.Add( _
        After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count))
    reportSheet.Cells(1, 1).Value = "Worksheet"
    reportSheet.Cells(1, 2).Value = "PivotTable name"
    nextRow = 2

    ' Record each PivotTable outside the new report sheet.
    For Each sourceSheet In ThisWorkbook.Worksheets
        If sourceSheet.Name <> reportSheet.Name Then
            For Each pivot In sourceSheet.PivotTables
                reportSheet.Cells(nextRow, 1).Value = sourceSheet.Name
                reportSheet.Cells(nextRow, 2).Value = pivot.Name
                nextRow = nextRow + 1
                found = True
            Next pivot
        End If
    Next sourceSheet

    If Not found Then
        reportSheet.Cells(2, 1).Value = "No PivotTables found."
    End If

    reportSheet.Columns("A:B").AutoFit
End Sub

The code uses ThisWorkbook, meaning the workbook that contains the macro. If you place the macro in a separate personal macro workbook, it will inventory that macro workbook instead of the workbook you meant to inspect. For a one-off task, store the code in a copy of the target workbook or adjust the workbook reference carefully. On Mac, the Visual Basic Editor is available in desktop Excel, though keyboard shortcuts and menus may differ; use the Developer tab’s Macros command if needed.

Common problems and name-related mix-ups

The PivotTable Analyze tab is missing: The active cell is probably outside the report, or the ribbon is collapsed. Click a cell inside the PivotTable and expand the ribbon. If the report is protected, selection or editing may also be restricted by worksheet settings.

The name box looks like a normal cell reference: Make sure you are reading the PivotTable Name field on the contextual tab, not the Name Box next to the formula bar. The latter may show something like B4, which is the selected cell address.

Ctrl+F does not find the name: Find searches worksheet content; a PivotTable object name is not ordinary cell text. Typing PivotTable2 into the Find dialog will not reliably locate the object. Use the contextual name box to inspect a selected report, or produce an inventory with VBA.

A source name seems to be missing: A PivotTable can use data from an Excel table, a range, an external connection, or the Data Model. Its own object name remains separate from that source. Also, multiple PivotTables may share a PivotCache, the stored data and settings used by reports; the cache is not the report’s name. Do not rename the source table expecting the PivotTable name to change.

When descriptive names are worth using

For a small workbook with one report, leaving the default name is usually harmless. Descriptive names become valuable when a workbook has several reports or is maintained with VBA. For example, a macro can refer to a report by its name rather than relying on its position in a worksheet’s PivotTables collection. If a user inserts another report earlier in that collection, position-based code may refer to the wrong one; a clear object name makes the intent easier to follow.

Names also help during handoffs and troubleshooting. A short inventory can show whether the expected report exists, which sheet contains it, and whether a report was duplicated or renamed. Keep names stable if other workbook code depends on them: renaming a PivotTable may require updating VBA that refers to the old name. A name does not, by itself, document the report’s filters, source, or refresh status, so record those separately when they matter.

Frequently Asked Questions

Can I find a PivotTable name without selecting the PivotTable?

For one report, Excel exposes the name in the contextual PivotTable Analyze tab after you select it. To find names without visiting each report manually, create a workbook inventory with VBA or another automation method that reads the PivotTables collection.

Does Excel’s Name Manager show PivotTable names?

No. Name Manager lists defined names, not PivotTable object names. Select the report and check the PivotTable Name box, or use a macro to list PivotTable names across worksheets.

Can I search for a PivotTable name with Ctrl+F?

Not reliably. Ctrl+F searches worksheet values and formulas, while the PivotTable’s object name is not normally displayed as cell content. Use the contextual tab or a generated inventory instead.

Can two PivotTables have the same name?

Excel requires PivotTable names in a workbook to be distinct. If you try to give a report a name already in use, choose a different name. A useful naming pattern includes the subject or grouping, such as SalesByRegion.

Is the PivotTable name the same as its source table or PivotCache?

No. The PivotTable name identifies the report object. The source table or connection identifies where its data comes from, while a PivotCache is the stored data and settings that one or more PivotTables can use.

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.