You need to set the EnableDataValueEditing property of the PivotTable to True. Note that your values will get overwritten again if you refresh the table though.