If you look at the Me object in the local window all the objects are there except the PivotTable collection. If you are changing the name of a pivottable field, you must type a new name for the field." This cell essentially acts as a search bar, allowing the user to type in what they are looking for rather than select it from a drop-down list. PivotTable. Press F7 to start spell check in Excel. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If the pivot table name was different, I'd expect an error about the object, not the pivot tables property of the worksheet. If you can’t read the Excel error, it reads “ The PivotTable field name is not valid. For an alternative way to create a PivotTable report based on a PivotTable cache, see the Add method of the PivotTables object.. It may not be what you're expecting it to be. After many hours trying to track down the problem I found that Excel 2010 had created 3 identical names, each with different ranges. This example creates a new PivotTable cache based on an OLAP provider, and then it creates a new PivotTable report based on the cache at cell A3 on the active worksheet. If the source data is non-OLAP (non-OLAP source data), the unique field is a PivotTable field. Unfortunately it is the correct sheet that is selected. Click Refresh again so we can show the 2015 data in our Pivot Table report: Voila! So I'm guessing that either the active sheet at that point in the macro is not the one you expect it to be, or else the pivot table isn't an excel pivot table  directly on that sheet. To create a Pivot Table report, you must use data that is organized as a list with labeled columns. The big caveat is that PT.DataPivotField is always something (Not Nothing) even if the Values field isn’t actually visible/used in the pivot table, i.e., a pivot table with just one data field. The pivotTable field name is not valid. or "A PivotTable report cannot overlap another PivotTable report." If you are changing the name of a PivotTable field, you must type a new name for the field." Making any changes to the spreadsheet with macros enabled and trying to save them causes Excel just to close (no error messages or warnings), without the save being effected. STEP 4: Right click on any cell in the first Pivot Table. Hi everyone, I found an excellent macro this morning that allows the user to filter a pivot table based on the value found in a specific cell. Be careful, by default, Excel does not check Capitalized Werds (whoops). We’re sorry. In our example, we selected cell G5 and click OK. Thanks for the reply. Visit the post for more. Run-time error 1004. Remarks. To create a PivotTable report, you must use data that is organized as a list with labeled columns. Example. "Run-Time Error '1004': The pivotTable field name is not valid. PivotTable Error: Field Name Is Not Valid. If you are changing the name of a pivottable field, you must type a new name for the field." To create a PivotTable, you must use data that is organized as a list with labeled columns. Pivot Table Field Name Is Not Valid Vba you. And I still think it's worth the attempt of recording a macro and selecting the pivot table, just to see how that refers to the pivot table. You are able to fix the overlapping Pivot Tables! If you select A1 and press End+RightArrow does it take you to the last column in your headings? If you are changing the name of the Pivot Table field, you must type a new name for the field." Run-time error'1004': Method 'Open' of object 'Workbooks' failed Below Copying the macro-activated worksheet from one workbook to another "Run-time error" 1004 '' I am trying to make a macro that will allow me to drop this very commonly used worksheet directly into the files we need it in. To create a pivot table, you need a heading for each column. To create a PivotTable report, you must use data that is organized as a list with labeled columns. Jan 27, 2009 I successfully created two PivotTables two days ago, but when I added more rows of data to the source worksheet I could not refresh either PivotTable view. The error is "Run-time error '1004': The Pivot Table field name is not valid. The problem originally started when Excel crashed while refreshing external data feeding the pivot table. If you are changing the name of the Pivot Table field, you must type a new name for the field." While creating a new PivotTable or refreshing data in the existing PivotTable, you may come across a Pivot Table error stating: “ The PivotTable field name is not valid. Change the Sheet Name, Pivot Table Name & Field to sort. The below line causes the above error: ActiveSheet.PivotTables("PivotTable1").PivotFields("MFLITM").CurrentPage = Me.ComboBox1.Value. Please post a list of your headings. Any suggestions how to repair the spreadsheet, or how I can force VBA to see the PivotTables collection? _