View original (French)

Lock filter in a pivot table

Fred -  
 eugene-92 -
Hello,
I would like to know if it is possible to lock filters in a pivot table and how to do it without using VBA (as I don’t know it)
Thank you in advance for your response 

<code><code xml>
</code></code>
Configuration: Windows / Firefox 68.0

2 answers

  1.
    Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     
    Hello.

    I didn't understand your request "lock the filters": what exactly do you want?

    I also didn't understand the end of your message with <code> ...

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
  2. eugene-92
     
    Good evening,
    When you have data and a pivot table on the same sheet, you cannot protect that sheet, otherwise the pivot table will not function.
    Solution 1: write a macro that will unprotect the sheet, then activate the pivot table, and then re-protect the sheet.
    Solution 2: without a macro, enter the data on a sheet where we will lock the formulas and protect it, and place the pivot table on another sheet that should not be protected.
    There are probably other ways, I'm searching...
    An example of solution 2:
    Best regards.
    https://www.cjoint.com/c/KHuqwYA7wmA

    Ps:
    And the pivot table is protected, even though its sheet is not...
    Ps 2:
    The same, the pivot table being obtained without modifications unlike the previous one, which I had reworked to improve the presentation.
    https://cjoint.com/c/KHuqSmLOyCA
    If I understood the question correctly...
    0