+ Reply to Thread
Results 1 to 4 of 4

Repeat All Item Labels - Not working

  1. 04-02-2014, 05:52 PM #1
    pizzalover
    pizzalover is offline
    Registered User
    Join Date
    10-27-2009
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2003
    Posts
    10

    Question Repeat All Item Labels - Not working

    Hello all,

    Having a strange issue with my Pivot Table. I have selected "Repeat All Item Labels" but as you can see, they're still being grouped/merged. Any ideas would be great

    pivot-problem.jpg
    Reply With QuoteRegister To Reply
  2. 04-02-2014, 05:55 PM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,009

    Re: Repeat All Item Labels - Not working

    Is that cell merged? Pivot tables should never group an item across multiple parent items.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  3. 04-02-2014, 06:11 PM #3
    pizzalover
    pizzalover is offline
    Registered User
    Join Date
    10-27-2009
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Repeat All Item Labels - Not working

    Thanks for the quick reply. Yes, the cell is merged. But when I try to unmerge it, it comes up with this error:
    pivot-problem.jpg
    Not sure how it got merged in the first place...
    Reply With QuoteRegister To Reply
  4. 04-02-2014, 06:14 PM #4
    pizzalover
    pizzalover is offline
    Registered User
    Join Date
    10-27-2009
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Repeat All Item Labels - Not working

    Problem fixed - "Merge and center cells with labels" was selected in the pivot table options.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Workaround missing "repeat item labels" function in excel 2007
    By amirah_almu7aka in forum Excel General
    Replies: 2
    Last Post: 02-27-2012, 01:03 PM
  2. Repeat labels in Pivot
    By henrikoz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2010, 08:04 AM
  3. [SOLVED] column labels repeat in excel
    By Karen in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-22-2005, 05:05 PM
  4. [SOLVED] How can I repeat labels in a Pivot Table?
    By anonymous in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-20-2005, 10:06 AM
  5. How do I repeat labels in a Pivot Table
    By teddy in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1