How do I fix the pivot table field name is not valid?

“The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.”

How do I make a pivot table field name valid?

How To Fix Pivot Table Field Name Is Not Valid Error?

1. 1: Alter First Row. In this case, you need to modify the table first row in a way that it should not contain a single empty cell.
2. 2: Modify the Range.
3. 3: Unhide/ Delete Empty Columns.
4. 4: Fix The Field Name Issue.
5. 10: Unmerge The Merged Cell.

Where is the pivot table field name?

Go to PivotTable Tools > Analyze, and in the Active Field group, click the Active Field text box. If you’re using Excel 2007-2010, go to PivotTable Tools > Options. Type a new name. Press ENTER.

How do I fix a pivot table in Excel?

Select any cell in the new 3-column table. On the Excel Ribbon, click the Insert tab, and click Pivot Table. The name of the new table should automatically appear in the Table/Range box. Choose a location for the pivot table, either a new sheet, or an existing sheet.

How do you activate a pivot table in Excel?

Start the Power Pivot add-in for Excel

1. Go to File > Options > Add-Ins.
2. In the Manage box, click COM Add-ins> Go.
3. Check the Microsoft Office Power Pivot box, and then click OK. If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list.

Why is data source not valid?

The issue data source reference is not valid may occur if you are opening a file directly from a website or directly from email attachments. In this case, the file will be opened from a temporary file, which will trigger this issue. In this case, you need to save this Excel file to the local drive.

How can I create a pivot table in Excel?

Create a PivotTable in Excel for Windows

1. Select the cells you want to create a PivotTable from.
2. Select Insert > PivotTable.
3. This will create a PivotTable based on an existing table or range.
4. Choose where you want the PivotTable report to be placed.
5. Click OK.

How do I turn on a pivot table report?

On the Insert tab, click Recommended PivotTables. Microsoft Excel will immediately display a few layouts, based on your data. In the Recommended PivotTables dialog box, click a layout to see its preview. If you are happy with the preview, click the OK button, and get a pivot table added to a new worksheet.