Suppress Pivot Table Refresh When Changing Custom Name in Field Value Settings

I often use the same file/pivot table for both month and weekly reporting. In my source data my field headers show 1,2,3,4..etc. This way I can use for month or weekly. But I often change the "Custom" name on the Field Value Settings to something more descriptive like "Jan" or "Week1"

The problem is that each time I update the the "Custom" name the Pivot Table auto refreshes and it takes forever to re-label all the columns.

Is there a way to suppress this refresh when updating the Custom Field Name?

Capture.JPG

Hi,

Can you not use descriptive headers (week1, week2 etc) in the raw data file instead of customizing the Pivot Table fields?

Hi cbatrody,

Thanks for the suggestion. However when you change the descriptive headers in the source file, its like building the table from scratch. When you refresh the pivot it removes all the selections in the "Value" field and then you have to manually replace them with the new names you had. Each time you do this the pivot table recalculates and this is the initial problem I had

What I am looking for is a way to make the pivot table stop from auto updating. If there were a way to change that routine to "manual" like you can do for formulas that is essentially what I would need.

-clint