Pivot table
how do i lock a pivot table, if it's at all possible?
RE: pivot table
Hello
Thank you for your question.
If you apply protection to your spreadsheet once you have created the pivot table, this should mean that no changes can be made to it.
To apply protection:
1. Go to Tools - Protection - Protect Sheet.
2. Enter a password to apply protection (recommended, otherwise it is easy to remove)
3. Click OK.
I hope this helps.
Amanda