Edit Pivot Table's Source-Table Formulas without Losing Columns in Pivot Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-729192%22%20slang%3D%22en-US%22%3EEdit%20Pivot%20Table's%20Source-Table%20Formulas%20without%20Losing%20Columns%20in%20Pivot%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729192%22%20slang%3D%22en-US%22%3E%3CP%3EWhenever%20I%20update%20any%20formula%20within%20my%20pivot%20tables'%20source%20data%20tables%2C%20the%20relevant%20column%20is%20lost%20from%20my%20connected%20pivot%20tables%20upon%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20an%20issue%20partly%20because%20it%20takes%20a%20lot%20of%20time%20to%20remake%20the%20pivot%20tables%20every%20time%20I%20need%20to%20adjust%20a%20formula%20in%20my%20source%20table.%20However%2C%20even%20if%20I%20get%20to%20a%20point%20where%20I%20no%20longer%20need%20to%20adjust%20formulas%2C%20my%20users%20need%20to%20be%20able%20to%20overwrite%20formulas%20within%20the%20source%20data%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Whenever I update any formula within my pivot tables' source data tables, the relevant column is lost from my connected pivot tables upon refresh.

 

This is an issue partly because it takes a lot of time to remake the pivot tables every time I need to adjust a formula in my source table. However, even if I get to a point where I no longer need to adjust formulas, my users need to be able to overwrite formulas within the source data table.

 

Help!

0 Replies