Remarks. You could also try recording a macro, selecting the pivot table and doing something minor with it (refresh it or change a number format). or "A PivotTable report cannot overlap another PivotTable report." You are using an out of date browser. Caption: Optional: Variant 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. The Workaround: As stated before, a workaround to this specific problem also exists. STEP 4: Right click on any cell in the first Pivot Table. Pivottable field name is not valid excel pivot table errors pivot table field name is not valid pivot table field name is not valid I had the same problem with some Pivot Tables after upgrading from Excel 2003 to Excel 2010. 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. 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. To create a Pivot Table report, you must use data that is organized as a list with labeled columns. Example. If you are changing the name of the Pivot Table field, you must type a new name for the field." To create a Pivot Table 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." This process with NAME your table with the default name of Table1. Instead of refreshing through function, please paste below code in the worksheet where pivot table is, as you click on that sheet, it will automatically refresh. For example, create a pivot table from a two-cell range and you’ll see that it still has a PivotDataField named Values. Visit our UserVoice Page to submit and vote on ideas! JavaScript is disabled. I could not repair the spreadsheet and moved my code into an early version which was OK. Now the above line causes an error. The error is "Run-time error '1004': The Pivot Table field name is not valid. It may not be what you're expecting it to be. "Run-Time Error '1004': 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. Run-time error 1004. To create a PivotTable report, you must use data that is organized as a list with labeled columns. 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. If you are changing the name of a PivotTable field, you must type a new name for the field. The pivotTable field name is not valid. Instead of using "activesheet", try specifying the sheet name. PivotTable. The pivot table error, "field name is not valid", usually appears because one or more of the heading cells in the source data is blank. Be careful, by default, Excel does not check Capitalized Werds (whoops). You must log in or register to reply here. In our example, we selected cell G5 and click OK. 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. The content you requested has been removed. If there's only one pivot table on the sheet, try using "PivotTables(1)" instead of specifying the table name. If you look at the Me object in the local window all the objects are there except the PivotTable collection. View 2 Replies View Related If the pivot table name was different, I'd expect an error about the object, not the pivot tables property of the worksheet. This is a complex spreadsheet which until recently was behaving itself. Visit the post for more. For an alternative way to create a PivotTable report based on a PivotTable cache, see the Add method of the PivotTables object.. The Pivot Table field name is not valid. 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. Name Required/Optional Data type Description; Field: Required: Object: The unique field on the server. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you press End+RightArrow again does it take you to IV1? To create a PivotTable report, you must use data that is organized as a list with labeled columns. I set the existing pivot tables to a named range data source, and set the named range within the VBA code itself. The problem originally started when Excel crashed while refreshing external data feeding the pivot table. If you select A1 and press End+RightArrow does it take you to the last column in your headings? We’re sorry. You’ll be auto redirected in 1 second. That's reinforced by your comment that there's no pivot tables collection on that worksheet. To create a pivot table, you need a heading for each column. 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. _