Pivot Table Label Not Updating - NOT a refresh problem

awan0126

New Member
Joined
Jul 6, 2011
Messages
2
Hello,
I'm having trouble updating the labels on my pivot table. These labels were added AFTER the original pivot table was created. I have since refreshed the data; tried dragging the field out of the "row label" and put it back in, but to no avail. The data shows up perfectly fine; I can sort by the label (it's an option in the dropdown menu) but the label itself does not show up in the pivot table. IE the table looks exactly as it should EXCEPT that there is an empty cell where the name of the label should show up.
This poses a problem when we then later reference the label for lookups.
Any idea what a possible solution for this may be??
Thank you!!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,611
Members
412,332
Latest member
hectamuptra
Top