I have a love-hate relationship with software. It’s great when it works, but frustrating when you get a cryptic error message. And these messages appear when you’re short on time and patience. This happened to me recently. Microsoft Excel was telling me my PivotTable field name is not valid. In this tutorial, I will show how to fix this with 2 easy solutions.
I was doing some editing on the spreadsheet I used for my Excel pivot table tutorial. Instead of seeing my results, I got the error below. Most times, I can quickly figure these scenarios out. Or, in the case of Excel formula errors, I use formula auditing. However, this one took some digging.
If you can’t read the Excel error, it reads, “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.“
My solution came down to 2 separate problems.
Solution 1: Unhide Excel Columns
The spreadsheet I was using was extensive. It had 121 columns, and I hid many because I wasn’t using them. I decided to unhide all the columns to see if this was the only issue causing the error.
- Click the Select All button to the left of cell A1.
- Right-click any column heading and select Unhide.
- Try your Pivot Table again.
In my case, I still got the error.
Solution 2: Delete Empty Excel Columns
The next fix took a bit longer and did require that I have all columns visible. This spreadsheet had some columns with headers but no values in any of the cells. Yes, that’s why I hid them.
In my case, I thought it would be easier to make a copy of my spreadsheet and then delete these columns. This way, I still had the original file.
It worked when I created my Pivot Table on the smaller working file.