Hi,
What is the best way to rename items within the pivot page break?
I set up a consolidated pivot table to consolidate all the months. The workbook was setup up one sheet per month.
In the creation of the consolidated pivot, I chose to create 1 page break. I then renamed the page break into "MONTH".
The items within the page break are months. They were then renamed to the appropriate months. I renamed the item by selecting the item and overwriting the cell. However, when I refreshed the data the renamed months reverted back to the original name which was "Item 18".
How can this be overcome?
Thanks Excel buddies.....
What is the best way to rename items within the pivot page break?
I set up a consolidated pivot table to consolidate all the months. The workbook was setup up one sheet per month.
In the creation of the consolidated pivot, I chose to create 1 page break. I then renamed the page break into "MONTH".
The items within the page break are months. They were then renamed to the appropriate months. I renamed the item by selecting the item and overwriting the cell. However, when I refreshed the data the renamed months reverted back to the original name which was "Item 18".
How can this be overcome?
Thanks Excel buddies.....