Pivot Table “Muscle Memory” Problem

Gian624

Board Regular
Joined
Jul 23, 2009
Messages
91
I am somewhat of a novice with Pivot Tables. One problem I am having that no one seems able to help me out with is that when I update and refresh my pivot table, it seems like it has a muscle memory with the drop down choice boxes.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
For example:
Lets say I have three customers that I have labeled 01 Target, 02 Walmart and 03 Bed Bath and Beyond. If I want to change 01 Target to 02 Target and 02 Walmart to 01 Walmart, it works in the pivot table and shows the proper data but if I try to choose the customer from a drop down box, it remembers the customers as labeled as they were before I made the changes AND the current look.
<o:p></o:p>
I will see: 01 Target, 02 Target, 01 Walmart and 02 Walmart in the drop down box but the data will only show up in the pivot table associated with the proper customers as they are labeled in the data source.
<o:p></o:p>
Does anyone know how to make it so the drop down choice boxes only show what the data source says and how to clear out the “muscle memory” so I don’t have to rebuild the pivot table every time I make an adjustment?
<o:p></o:p>
Thank you so much!!
Matt
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,089,195
Messages
5,406,738
Members
403,105
Latest member
gituncar

This Week's Hot Topics

Top