excelavon

Excel Pivot Table Field Name Not Valid? Fix It

Charts & pivot tables · Updated November 2, 2026

Excel Pivot Table Field Name Not Valid? Fix It

The Excel “PivotTable field name is not valid” error usually means the selected source range has a missing column heading, or Excel is treating the wrong row as the header row. Give every source column a nonblank, unmerged heading, then create the PivotTable again or correct its source range.

Why Excel shows this error

A PivotTable turns each column in a source list into a field that can be placed in the Rows, Columns, Values, or Filters areas. To identify those fields, Excel reads the first row of the selected source range as the set of column names. If one of those heading cells is blank, Excel cannot create a complete field list and may display the error.

The problem is often not in the records themselves. A sheet can contain hundreds of complete rows and still fail because one header cell is empty, a heading is merged across columns, or the selected range starts on a title row instead of the actual headings. Excel may also be including empty columns beside the data, which leaves it with a blank field name.

Spaces, punctuation, or a heading such as “Sales ($)” are normally acceptable. The key requirement is that each source column has a usable heading in the first row of the range. Giving fields distinct, descriptive names is also good practice, even when duplicate labels are not the direct cause of this particular message.

Quick fix: check every column heading

In Excel for Microsoft 365 on Windows, first inspect the source list rather than changing the PivotTable layout. Use this sequence:

  1. Close the error message and go to the worksheet containing the source data.
  2. Find the exact row that contains the field names, such as Date, Region, Product, and Amount.
  3. Check every column in the intended source range. Type a clear label into any empty heading cell; for example, name an otherwise unlabeled column Notes.
  4. Unmerge any cells in the heading row. If a heading spans several columns, give each column its own separate name.
  5. Select a cell inside the corrected list, then choose Insert > PivotTable.
  6. In the Create PivotTable dialog, check that the proposed table or range includes the header row and only the intended columns. Choose where to place the PivotTable and select OK.

If the source is already an Excel table, inspect its header row too. Click in the table and check the names shown at the top of each column. A table can make the source easier to manage, but it does not make an empty or unsuitable heading meaningful for a PivotTable.

What counts as a valid header row

A good source range has one row of field names followed immediately by records. Each heading should describe the values beneath it, and each column should represent one kind of information. For example, a sales list might have Order Date, Customer, Region, Item, Quantity, and Revenue as its six headings.

Excel uses the first row of the selected range as the headings; it does not search down the sheet to find the row that looks most like a header. If row 1 is a report title and row 3 contains the actual labels, selecting A1:F200 can make Excel treat the title row as the header row. Instead, select the range beginning at the actual header row, such as A3:F200, or remove the title from the source block.

  • A blank cell: Replace it with a useful name such as Comments or Category.
  • A merged heading: Unmerge it and enter a separate name for each affected column.
  • A heading that looks blank: A formula returning an empty string or spaces can be hard to spot. Replace it with a visible label, or clear the cell and enter a proper heading.
  • Repeated labels: Make names distinct, such as Sales Amount and Tax Amount, so fields are easy to identify and maintain.

Do not add a heading merely to silence the message if the column is outside the data you want to summarize. The better fix may be to narrow the selected range so it excludes unused columns.

Make sure the selected source range is correct

When creating a PivotTable, Excel often guesses the source range from the active cell and the surrounding data. That guess can be wrong if there are blank rows or columns, a separate note next to the list, or multiple blocks of data on the same sheet. In the Create PivotTable dialog, review the Table/Range box before proceeding. It should start at the heading row, cover all records, and include only columns with headings.

For example, suppose the real list occupies A1:D250, with headings in row 1, but a note in F1 makes the detected range extend through column F. If columns E and F are empty within the source block, Excel may encounter a field without a heading. Select the actual range A1:D250 or move the note elsewhere, then create the PivotTable from that clean range.

A blank row between records does not automatically mean every PivotTable will fail, but it can make Excel’s automatic range detection unreliable and can split what should be one list. Keep the source data in a continuous rectangular block: one record per row, one field per column, and no decorative title rows or subtotal rows inside the records.

Fix an existing PivotTable or changed data source

If the error appears while refreshing or editing an existing PivotTable, check whether its source range still points to the intended data and whether the header row has changed. On Windows desktop Excel, click inside the PivotTable and choose PivotTable Analyze > Change Data Source. Confirm or select the correct range, including its header row, and then refresh the PivotTable.

Refreshing alone does not repair a source range that still includes a blank header or begins on the wrong row. Correct the source first. If a heading was renamed or a new column was inserted, check the field list after the source is updated; the field names may differ from those previously used in the layout.

If the data grows regularly, consider converting the source range to an Excel table: select a cell in the list and choose Insert > Table, then confirm that My table has headers is selected only when the first row really contains headings. A PivotTable based on a table can include newly added table rows when refreshed, reducing the need to edit a fixed range. It still requires valid headings.

Other source-data problems worth checking

Some problems are mistaken for a header error because they occur during the same setup process. Check the whole source structure, especially if you have filled every heading and still see the message:

  • The range starts one row too high or low. Verify the first row in the Table/Range box is the actual header row, not a title, blank line, or first data record.
  • The range includes unused columns. Remove blank columns from the selection, or give them meaningful headings if they belong in the data.
  • The headings are merged. A merged cell cannot provide independent field names for each underlying column. Unmerge it and label each field individually.
  • The source is laid out like a report. Repeated headings, subtotals within the list, and notes mixed into records can make a clean PivotTable source difficult to identify. Keep those elements outside the source block.
  • The source range was edited after the PivotTable was made. Check Change Data Source and confirm that the PivotTable is still connected to the intended list or table.

Duplicate headings are worth cleaning up because they make the field list confusing and can lead to naming conflicts. However, the most important diagnostic for this exact error is still to find an empty, merged, or incorrectly selected heading row. Do not assume that every unusual heading character is forbidden; ordinary spaces and punctuation in descriptive labels are generally fine.

Prevent the error with a clean data layout

A little structure makes PivotTables easier to create, refresh, and audit. Use one row per transaction or observation and one column per attribute. Put the field names in a single top row, avoid merged cells, and keep explanatory notes outside the source list. For example, do not combine a customer name and address in one field if you need to analyze them separately; use separate columns with clear headings.

When the data is ready, convert it to a table with Insert > Table and confirm the header option accurately reflects the first row. Use a table name and column names that make sense to the people who will maintain the workbook. This is particularly useful when new records are appended over time, because the table can expand as rows are added and the PivotTable can be refreshed against that table.

On Excel for Mac, the same basic checks apply: inspect the source headings, correct the range, and create or update the PivotTable using the available Insert and PivotTable controls. Ribbon labels and dialog layouts can differ by platform or release. Excel for the web also has PivotTable tools, but some creation and source-editing controls may differ from the Windows desktop steps; if a required control is not available, open the workbook in desktop Excel.

Frequently Asked Questions

Can blank cells in the data cause this error?

Blank cells in ordinary data rows are not the same as a blank heading. The error most commonly points to an empty field name in the first row of the selected source range. You can still have blank values in records, although missing data may affect how you interpret the resulting summary.

Do PivotTable column names have to be unique?

Use distinct names even when Excel can accommodate repeated labels in a particular source setup. Unique names make the PivotTable field list clearer and help avoid naming conflicts. If two columns are both called Amount, rename them to something specific, such as Net Amount and Tax Amount.

Will refreshing the PivotTable fix the error?

Only if the source data and range are already valid. Refreshing updates the PivotTable from its source; it does not fill in a blank heading or correct a range that starts on the wrong row. Fix the source or use PivotTable Analyze > Change Data Source first, then refresh.

Can I leave a column heading blank if I do not use that field?

Not if that column is included in the source range used to create the PivotTable. Either give the column a heading or exclude the entire unused column from the selected range. A blank field inside the range can prevent Excel from creating the PivotTable even if you do not plan to use that field.

Why does the error appear after I add a new column?

The new column may have been included in the PivotTable source without a heading, or the PivotTable may still be using an older source range. Add a label to the new column, check the source range, and refresh or update the PivotTable. If the source is an Excel table, confirm the new column has a proper table header.

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.