I'am trying to edit pivot table data using script editor.
Example;
<x:PivotItem
<x:NameItem1</x:Name
</x:PivotItem
<x:PivotItem
<x:PivotItem
<x:NameItem2</x:Name
</x:PivotItem
<x:PivotItem

I need to change "Item1" to say June.
Therefore I change every instance of the word "Item1" to
June then save & refresh, open up excel pivot table to find Item1 changed to
June, YEAAA!!!!
BUT all the data for Item1 has disappeared????
How can I change Item1 to June and keep Item1's data????????