i only want to lock certain cells when using a pivot table

Q

Quintin

Joined
Jun 11, 2011
Messages
1
Reaction score
0
i only want to lock (protect) certain cells when using a table - eg: when working in or with a pivot table the person / staff member can fill in date then tab fill in the next data required - tab but do not want then to change / modify data due to the next two columns or what ever having formulas in them
thank you
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
HOW DO I LOCK CERTAIN CELLS 2
Pivot Table 1
remove Absolute references when copying from pivot table 4
Refreshing Pivot Table on a protected spreadsheet tab 1

Top