Home

Protect a worksheet that has a INDEX function

%3CLINGO-SUB%20id%3D%22lingo-sub-636289%22%20slang%3D%22en-US%22%3EProtect%20a%20worksheet%20that%20has%20a%20INDEX%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636289%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20four%20worksheets%20of%20data%20and%20a%20fifth%20worksheet%20that%20summarizes%20that%20data%20using%20INDEX%20functions%20(referencing%20the%20first%20four%20worksheets).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20people%20to%20be%20able%20to%20see%20the%20Summary%20worksheet%20but%20not%20edit%20it%20directly.%26nbsp%3B%20But%20I%20want%20them%20to%20be%20able%20to%20modify%20the%20first%20four%20worksheets%20and%20have%20the%20Summary%20worksheet%20automatically%20updated%20accordingly.%26nbsp%3B%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20protect%20the%20Summary%20page%20to%20keep%20it%20from%20being%20edited%20directly%20but%20when%20I%20try%20to%20edit%20one%20of%20the%20first%20four%20worksheets%2C%20I%20get%20an%20error%20that%20the%20cell%20that%20I'm%20trying%20to%20edit%20is%20on%20a%20protected%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20going%20about%20it%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-636289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
bvelke
Occasional Contributor

I have a workbook with four worksheets of data and a fifth worksheet that summarizes that data using INDEX functions (referencing the first four worksheets).

 

I want people to be able to see the Summary worksheet but not edit it directly.  But I want them to be able to modify the first four worksheets and have the Summary worksheet automatically updated accordingly.  Is this possible?

 

I protect the Summary page to keep it from being edited directly but when I try to edit one of the first four worksheets, I get an error that the cell that I'm trying to edit is on a protected worksheet.

 

Am I going about it wrong?

 

Thanks for any help.

Related Conversations