+ Reply to Thread
Results 1 to 5 of 5

Grouping of one pivot affecting the grouping and formatting of other pivots from Same data

  1. #1
    Registered User
    Join Date
    07-24-2014
    Location
    Chennai
    MS-Off Ver
    2010
    Posts
    3

    Question Grouping of one pivot affecting the grouping and formatting of other pivots from Same data

    Hi all,

    I preparing a multiple pivots from single source data and these pivots are build in different sheets individually.

    But everytime i refresh the pivot with new data, the grouping, filters and formats gets changed for all pivots. I have tried to remove the tick mark for auto format in the pivot options but still the issue persist.

    Can anyone help me to resolve the issue.

    thanks.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Grouping of one pivot affecting the grouping and formatting of other pivots from Same

    Hi,

    Welcome to the Forum.

    Did you uncheck "Autofit column widths on update" from all Pivots? Also, you need to ensure you select "Preserve cell formatting on update" tick mark. This will ensure that the formatting does not get abolished during refresh.

  3. #3
    Registered User
    Join Date
    07-24-2014
    Location
    Chennai
    MS-Off Ver
    2010
    Posts
    3

    Re: Grouping of one pivot affecting the grouping and formatting of other pivots from Same

    Hi thanks for you response.

    I have unticked "Autofit column widths on update" and retained "Preserve cell formatting on update"options in pivot options. I believe this is to do more with Data cache as read in one of the thread in this forum. I am trying with options provided in the threads.

    Let check it!!!

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Grouping of one pivot affecting the grouping and formatting of other pivots from Same

    Hi,

    Did you manage to resolve the issue?

  5. #5
    Registered User
    Join Date
    07-24-2014
    Location
    Chennai
    MS-Off Ver
    2010
    Posts
    3

    Re: Grouping of one pivot affecting the grouping and formatting of other pivots from Same

    Yes, All you have to do is to create pivot tables through Pivot wizard instead of using insert pivot tables. But still you have to untick "Autofit column widhs on update"

    Check out it works

+ 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] Multiple Pivots - separate grouping
    By Leszczur in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-20-2014, 08:57 AM
  2. Pivot table grouping by date. Formatting inconsistency
    By Richard Buttrey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2014, 07:16 AM
  3. [SOLVED] Grouping events based on Time Intervals in Pivots
    By hutch2hutch in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-13-2013, 05:10 AM
  4. [SOLVED] Changing grouping on one one pivot table affects other pivots - no good
    By andylists@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 12:13 AM
  5. [SOLVED] Formatting the date column for grouping in a pivot table
    By highlystrung in forum Excel General
    Replies: 7
    Last Post: 05-09-2012, 01:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1