Do pivot tables work after locking some columns?

%3CLINGO-SUB%20id%3D%22lingo-sub-1304526%22%20slang%3D%22en-US%22%3EDo%20pivot%20tables%20work%20after%20locking%20some%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1304526%22%20slang%3D%22en-US%22%3E%3CP%3EI%60ve%20noticed%20after%20unlocking%20some%20columns%20in%20sheet%201%20(Data)%2C%20and%20protecting%20the%20Data%20sheet%2C%20that%20my%20pivot%20table%20in%20sheet%202%20(Analyze)%20being%20fed%20from%20the%20Data%20sheet%2C%20no%20longer%20works%2C%20is%20this%20correct%3F%20(It%20appears%20that%20partially%20protected%20sheets%20stop%20pivot%20tables%20from%20calculating%20data%3F)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20the%20table%20in%20sheet%201%20(Data)%20no%20longer%20populates%20down%20the%20page%20once%20its%20rows%20are%20full.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20protect%20my%3B%20day%2C%20week%2C%20month%2C%20year%2C%20GST%2C%20and%20subtotal%20columns%20from%20being%20editable.%3C%2FP%3E%3CP%3EBut%20when%20I%20do%20protect%20those%20cells%2C%20the%20pivot%20table%20stops%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20find%20after%20unprotecting%20the%20worksheet%201%20(Data)%2C%20the%20data%20table%20on%20sheet%201%20no%20longer%20elongates%20downward%20when%20dragged.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20protecting%20sheets%20breaks%20both%20data%20tables%20and%20pivot%20tables%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epassword%20cell8%20(or%20Cell8)%20unprotects%20sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eworksheets%20attached%3A%3C%2FP%3E%3CP%3Eoriginal%3A%20revenue%20dashboard%20version%207%3C%2FP%3E%3CP%3Epartial%20protection%3A%20practice%20locking%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1304526%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

I`ve noticed after unlocking some columns in sheet 1 (Data), and protecting the Data sheet, that my pivot table in sheet 2 (Analyze) being fed from the Data sheet, no longer works, is this correct? (It appears that partially protected sheets stop pivot tables from calculating data?)

 

And the table in sheet 1 (Data) no longer populates down the page once its rows are full.

 

I want to protect my; day, week, month, year, GST, and subtotal columns from being editable.

But when I do protect those cells, the pivot table stops working.

 

I also find after unprotecting the worksheet 1 (Data), the data table on sheet 1 no longer elongates downward when dragged.

 

It seems protecting sheets breaks both data tables and pivot tables?

 

password cell8 (or Cell8) unprotects sheet 1.

 

worksheets attached:

original: revenue dashboard version 7

partial protection: practice locking 2

 

 

 

 

 

 

 

 

 

0 Replies