98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table
Pivot table
Resolved · Low Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |