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

Answer 1 / 2
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
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
Answer 2 / 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