Pivot table won't refresh.

%3CLINGO-SUB%20id%3D%22lingo-sub-168009%22%20slang%3D%22en-US%22%3EPivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20getting%20an%20error%20when%20I%20try%20to%20refresh%20PivotTable%20data%20-%20and%20it's%20not%20updating%20a%20field%20I've%20made%20changes%20to.%26nbsp%3B%20The%20error%20message%20is%3A%20%22The%20pivot%20table%20field%20name%20is%20not%20valid.%20To%20create%20a%20valid%20PivotTable%20report%2C%20you%20must%20use%20data%20that%20is%20organized%26nbsp%3Bas%20a%20list%20with%20labeled%20columns.%20If%20you%20are%20changing%20the%20name%20of%20a%20PivotTable%20field%2C%20you%20must%20type%20a%20new%20name%20of%20the%20field.%22%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22thread-message-content-body-text%20thread-full-message%22%3E%0A%3CP%3EThing%20is%2C%20I%20am%20using%20tables%20with%20labeled%20columns%2C%20I've%20tried%20renaming%20the%20pivot%20table%2C%20the%20fields%2C%20everything%20I%20can%20think%20of.%26nbsp%3B%20Nothing%20works.%20So%20I%20end%20up%20re-creating%20the%20PivotTable%20over%20and%20over%2C%20but%20it%20still%20isn't%20refreshing%20the%20data.%3C%2FP%3E%0A%3CP%3EHelp!%3C%2FP%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-168009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-196214%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-196214%22%20slang%3D%22en-US%22%3Ecan%20u%20upload%20a%20dummy%20sample%20file%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-192737%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-192737%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20error%20as%20well%2C%20and%20no%20columns%20have%20changed.%20I%20add%20a%20few%20rows%20at%20the%20bottom%20of%20my%20data%20sheet%20and%20I%20can't%20refresh%20any%20pivot%20tables%20at%20all.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168028%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168028%22%20slang%3D%22en-US%22%3E%3CP%3EProbably%2C%20you%20are%20trying%20to%20refresh%20a%20pivot%20table%20where%20the%20columns%20in%20the%20source%20data%20may%20have%20changed.%3C%2FP%3E%0A%3CP%3Eto%20fix%20the%20issue%2C%20try%20to%20remove%20the%20pivottable%20labels%2C%20refresh%20then%20see%20whether%20you%20can%20still%20find%20those%20columns%20in%20the%20pivottable%20fields.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2331727%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2331727%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%20I%20know%20this%20post%20is%20old%2C%20but%20I%20had%20the%20same%20issue%20thought%20I'd%20share%20the%20solution%20I%20found%20in%20case%20it%20helps%20others.%26nbsp%3B%20If%20I%20update%20the%20Pivot%20Table%20source%20to%20use%20the%20name%20of%20the%20table%20that%20is%20being%20refreshed%20(found%20in%20the%20Name%20Manager%20on%20the%20Formulas%20tab)%20it%20refreshes%20successfully.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332148%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332148%22%20slang%3D%22en-US%22%3EGood.%20thanks%20for%20sharing.%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm getting an error when I try to refresh PivotTable data - and it's not updating a field I've made changes to.  The error message is: "The pivot table field name is not valid. To create a valid 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 of the field."

Thing is, I am using tables with labeled columns, I've tried renaming the pivot table, the fields, everything I can think of.  Nothing works. So I end up re-creating the PivotTable over and over, but it still isn't refreshing the data.

Help!

5 Replies

Probably, you are trying to refresh a pivot table where the columns in the source data may have changed.

to fix the issue, try to remove the pivottable labels, refresh then see whether you can still find those columns in the pivottable fields.  

I have this error as well, and no columns have changed. I add a few rows at the bottom of my data sheet and I can't refresh any pivot tables at all. 

can u upload a dummy sample file?

Hey! I know this post is old, but I had the same issue thought I'd share the solution I found in case it helps others.  If I update the Pivot Table source to use the name of the table that is being refreshed (found in the Name Manager on the Formulas tab) it refreshes successfully.

Good. thanks for sharing.