View original (French)

Sheet Segments and Protection

Solved
Oceanik. Posted messages 65 Status Member -  
Oceanik. Posted messages 65 Status Member -
Hello,

Is it normal for the segments to stop working when a sheet is protected? Is there a way to keep them always active? Thank you!

3 answers

  1.
    ALS35 Posted messages 1034 Registration date   Status Member Last intervention   147
     
    Good evening,

    As Raymond suggested, you need to go to the list of actions to allow when you protect your sheet and check "Edit objects" and what you want to do "Auto filter" and/or "Pivot table"

    Best regards.
    3
  2. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 490
     
    Yes, that's normal.
    Try with the sheet protection settings; but I doubt it'll work...

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    1
  3. Oceanik. Posted messages 65 Status Member
     
    Thank you all for your support.
    0
    1. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 490
       
      ... but you didn't indicate whether it worked: did you achieve satisfaction?
      0
      1. Oceanik. Posted messages 65 Status Member > Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention  
         
        I am satisfied. Thank you very much!!
        0