Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot table

ResolvedVersion 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

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.