Changed my pivot table "mapping" but subtotal row label not reflecting updates

[iamanexcelnoob]

so my pivot table is running off of a mapping table that matches a number to a name. i updated the name (lets call them "old" and "new"). the "new" name shows atop the pivot table (first column, top row), but the subtotal is showing the "old" name.

i triple checked to make sure the old name doesn't exist anywhere in the data or the mapping and refreshed the entire sheet and it still remains.

thoughts?

 

[jkpieterse]

In the pivottable properties there is a setting that controls whether data which is removed from the source is also removed from the PT (Data tab, "Number of items to retain per field", set to none)

 

[iamanexcelnoob]

In the pivottable properties there is a setting that controls whether data which is removed from the source is also removed from the PT (Data tab, "Number of items to retain per field", set to none)

unfortunately this wasn't the solution. it's so odd too because i changed the mapping for another line item and it did filter through to the subtotal line as well. i can't see any variances between the two.

i am scratching my head here.

 

[SpillerBD]

Turn off the Preserve Cell Formatting in the PivotTable options.

 

[iamanexcelnoob]

Turn off the Preserve Cell Formatting in the PivotTable options.

nope - wasn't that. strange, eh?

 

[iamanexcelnoob]

sorry to do this, but bump...

 

[jkpieterse]

Could you please describe in more detail (step by step) what you did precisely?

 

[iamanexcelnoob]

Could you please describe in more detail (step by step) what you did precisely?

sure i have a data pull which we ran a pivot table off of and broke out into multiple tabs (by product).

each product is identified by a number. we have a mapping table with all of the numbers mapped to the product names. on the data pull tab we run a lookup against the numbers to match it to the product names on the mapping tab.

i updated the mapping tab to reflect the new product name. the new product name flowed through automatically to the data tab via the lookup. i refreshed the entire report. one product update flowed through to the pivot table correctly where both the column title and the subtotal updated appropriately. the other did not - only the column title updated and the subtotal remained the "Old" product name.

sorry, that might not be easy to understand but can't think of a better way to describe.

 

[jkpieterse]

I assume you created the individual sheets with Pivots by using the "Show report filter pages" option. This option will create as many sheets as there are items in the page filter you selected. These sheets are each named by and fitlered for that field item. UPdating the content of that field will however NOT change the sheetnames in question, nor change the filter setting of each sheet, you will have to do that manually. Likewise, if a new item is added to the list, no new sheet is generated. You either manually copy one of the sheets and name it after the new item (and filter it), or you remove all product sheets and redo the Show Report filter pages.

 

[iamanexcelnoob]

I assume you created the individual sheets with Pivots by using the "Show report filter pages" option. This option will create as many sheets as there are items in the page filter you selected. These sheets are each named by and fitlered for that field item. UPdating the content of that field will however NOT change the sheetnames in question, nor change the filter setting of each sheet, you will have to do that manually. Likewise, if a new item is added to the list, no new sheet is generated. You either manually copy one of the sheets and name it after the new item (and filter it), or you remove all product sheets and redo the Show Report filter pages.

i agree and understand this process however i am not sure that solves the problem.

all the data is now correct, the column header was updated however the subtotal title remains the "old" name.

i would think that there would be something amiss with my process if the other product update didn't flow through correctly - but it did. just seems odd. im going to play around more and see if i can figure it out.