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
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies