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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

flexinau

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

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Unfortunately, redefining a consolidation range removes customized item labels.
 

Forum statistics

Threads
1,143,915
Messages
5,721,515
Members
422,369
Latest member
redinator

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
Top