+ Reply to Thread
Results 1 to 2 of 2

Pivot Groups Collapsing in 2016

  1. #1
    Registered User
    Join Date
    06-26-2008
    Location
    none
    Posts
    3

    Pivot Groups Collapsing in 2016

    I am creating groups in a pivot table. The problem arises after I save my data close the program and reopen the document later. After the document is opened the groups are renamed back to Group1 Group2 etc. and collapsed. There is no way to expand the groups (eg. the plus button is missing) and the only way to restore access to the group contents is to create a new group of any data which miraculously causes all the original groups to reappear. Has anyone had a similar situation and if so have you found a solution to the problem?

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Pivot Groups Collapsing in 2016

    Hi drew.mcintire,

    Have you tried opening the file in another Excel version, like 2013, or opening the file on another PC.

    It would help if could isolate the problem by doing these tests.
    Remember you are unique, like everyone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] shortcut for expanding/collapsing groups
    By BorisS in forum Excel General
    Replies: 5
    Last Post: 01-11-2017, 11:02 AM
  2. [SOLVED] calculating specific data from a pivot table to create a pivot chart in Excel 2016
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2016, 12:14 PM
  3. [SOLVED] Collapsing or Un-Collapsing Grouped Rows using VBA
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2015, 12:39 PM
  4. Replies: 1
    Last Post: 12-12-2014, 12:34 PM
  5. Pivot Table is collapsing
    By bcn1988 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-06-2013, 08:45 AM
  6. expanding/collapsing details in pivot table and scatterplot
    By woontime in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-28-2011, 09:22 PM
  7. Collapsing Groups while the cells are protected
    By karaf in forum Excel General
    Replies: 2
    Last Post: 01-11-2009, 11:37 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1