Pivot Table Page Break

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
122
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.....
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sorry I have not responded for a while Mark.
I went into the pivot table wizard after changing the item names. I amended the ranges to consolidate, but when I clicked on refresh, the item that I changed the range had its item name revert back to "Item 18" from its previous name (the name of the month that I changed the name to).

Hope this is enough detail....

Thanks Mark
 
Upvote 0

Forum statistics

Threads
1,219,030
Messages
6,145,878
Members
450,654
Latest member
lorento

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top