Pivot Table “Muscle Memory” Problem

[Gian624]

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-comfficeffice" /><o></o>
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></o>
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></o>
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></o>
Thank you so much!!
Matt

 

[akeys11]

I have excel 2003. I am trying to create a pivot table but it shows count instead of sum, which I need. How do I change this to reflect the sum of the data? (Thought I considered myself intermediate with Excel but the more I play in it the more I discover I'm definatly a beginner!!) (sorry i cant figure out how to make a new post)

 

[foverman]

Hello akeys11,

Welcome to the Forum.

In the table below

Excel Workbook
	A	B	C	D	E	F
11	Sum of Actual Hours			Period Quarter	Period Month	Week
12				2009-Q2	Grand Total
13
14	Resource Name	Task Name	Project Name
Resources by Manager

Excel 2003
Actual Hours is the data in the body of my table.
When I double-click Sum Of Actual Hours the dialog box lets me choose how I want to summarize the data, Sum, Count, Average, etc.

 

[Gian624]

Thank you Alex,
My Pivot is in fact sensitive and if I tried to modify it so it could be public, I'd probably end up with something that worked from your suggestions so I'll leave my post at that. All your suggestions have been much appreciated and they have worked in other examples we have tried... just not this one specific pivot.

Thanks again so much,
Matt