Can't rename Group in Excel Pivot Table

D

Danzo

New Member
Joined
Sep 5, 2009
Messages
1
I am using Excel 2003 and Windows XP. My issue is that I can't rename a group within a Pivot Table I'm using. Other groups within the level can be renamed, but the one I am having trouble with just goes back to it's original name (e.g., Group6) or something like that. If I enter a leading apostrpohe, it will take the new name, but the apostrope shows.

I've tried un-grouping and re-grouping everything, checking to make sure the data was all the same format and a variety of other things, but nothing works. This has happened to me intermittently in different spreadsheets. Why can't this one group be re-named when other groups within the sub-group can be re-named?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Dear Danzo,

Possible to print screen of pivot table problem as not sure why ?
 
Upvote 0
Hi

Maybe it is a problem with what you are trying to rename it to? Or does it simply not allow you to rename it to anything (eg a meaningless block of characters like "qwerty")?
 
Upvote 0
Hello,

The name you're trying to use may already exist, hence why you're having the problem.

You could "cheat" and simply add an empty space at the end of the name (bit like what you did with the apostrophe, but the space won't show). But I would advise checking further to make sure the name doesn't already exist to avoid potential issues further down the line.

Matty
 
Upvote 0
check to see if you are using a header name. excel pivot tables won't let you do this.
 
Upvote 0
Danzo said:
I am using Excel 2003 and Windows XP. My issue is that I can't rename a group within a Pivot Table I'm using. Other groups within the level can be renamed, but the one I am having trouble with just goes back to it's original name (e.g., Group6) or something like that. If I enter a leading apostrpohe, it will take the new name, but the apostrope shows.

I've tried un-grouping and re-grouping everything, checking to make sure the data was all the same format and a variety of other things, but nothing works. This has happened to me intermittently in different spreadsheets. Why can't this one group be re-named when other groups within the sub-group can be re-named?
Click to expand...

Hi,

To rename the group you should first delete the "groupped" variable in the pivot table by following these steps:

  • Right click a cell in your data table
  • Pivot Table options
  • Select Data Tab
  • In Retain Items Section select None in the drop down box
  • Hit ok
  • Refresh your Pivot Table
Then you can create again the groupped variable and renamed.
 
Upvote 0
rcosta said:
Hi,

To rename the group you should first delete the "groupped" variable in the pivot table by following these steps:

  • Right click a cell in your data table
  • Pivot Table options
  • Select Data Tab
  • In Retain Items Section select None in the drop down box
  • Hit ok
  • Refresh your Pivot Table
Then you can create again the groupped variable and renamed.
Click to expand...
It's great that someone answered this question eight years (!) after it was posted here - because 3 months later I have the same query. :cool: Thank you, this solution worked for me!
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Confused over pivot table calculations :-(
Replies
1
Views
240
number kruncher
N
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
564
RoryA
RoryA
S
  • Question
VBA or Slicer / Power Query - Is it possible to select pivot table fields (column headers)
Replies
1
Views
629
Sheila8659
S
M
  • Question
Turn day over day data into pivot chart filtered by name
Replies
1
Views
212
awoohaw
awoohaw
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
976
Alex Blakenburg
A

Forum statistics

Threads
1,214,643
Messages
6,120,702
Members
448,980
Latest member
CarlosWin

Share this page

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