+ Reply to Thread
Results 1 to 3 of 3

how to lock settings in pivot? stop updating info?

  1. #1
    Registered User
    Join Date
    10-07-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    18

    how to lock settings in pivot? stop updating info?

    Hi. Can anyone help me how to lock? pivot table?

    I created pivot and set a group by hours which is up to 04:30. Then I created another pivot from same data and would like to set group from 4:30 up to 10:00. But once I will set 2nd group to start from 04:30 and finish at 10:00 it will change the first pivot as well.

    Any ideas?
    pivots.xlsx

    thank you

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: how to lock settings in pivot? stop updating info?

    instead of using the Insert-Pivot table method for the second pivot table select your source data and press alt+dp to bring up the pivot table wizard and set up your pivot as normal. when asked if you want to share the same source to save memory choose no.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    10-07-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: how to lock settings in pivot? stop updating info?

    thank you very much for your help JosephP

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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