Home

spreadsheet protection

%3CLINGO-SUB%20id%3D%22lingo-sub-556179%22%20slang%3D%22en-US%22%3Espreadsheet%20protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556179%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ERequire%20some%20help%20to%20protect%20a%20spreadsheet%20which%20will%20be%20filtered%20to%20individual%20managers.%3C%2FP%3E%3CP%3EI%20require%20parts%20of%20the%20sheet%20to%20be%20locked%2C%20with%20other%20columns%20open%20for%20data%20input.%3C%2FP%3E%3CP%3E7%20Managers%2C%20each%20seeing%20only%20there%20respective%20business%20units%20once%20filtered%20by%20name.%3C%2FP%3E%3CP%3ECan%20anyone%20advise%20on%20how%20this%20can%20be%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Kindly%3C%2FP%3E%3CP%3EJ.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-556179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-556306%22%20slang%3D%22en-US%22%3ERe%3A%20spreadsheet%20protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556306%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339635%22%20target%3D%22_blank%22%3E%40JD_73%3C%2FA%3E%26nbsp%3BMy%20approach%20would%20be%20the%20other%20way%20around.%20Give%20each%20manager%20their%20own%20file%20with%20just%20their%20data%20for%20data%20entry.%20Then%20create%20a%20centralised%20report%20that%20pulls%20the%20data%20from%20all%20manager%20sheets.%20This%20could%20possibly%20be%20done%20with%20Power%20Query.%26nbsp%3B%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561910%22%20slang%3D%22en-US%22%3ERe%3A%20spreadsheet%20protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3BThank%20You%20Ingeborg%2C%20I%20will%20give%20that%20a%20go.%3C%2FP%3E%3C%2FLINGO-BODY%3E
JD_73
New Contributor

Hi,

Require some help to protect a spreadsheet which will be filtered to individual managers.

I require parts of the sheet to be locked, with other columns open for data input.

7 Managers, each seeing only there respective business units once filtered by name.

Can anyone advise on how this can be done.

 

Thank you Kindly

J.

2 Replies

@JD_73 My approach would be the other way around. Give each manager their own file with just their data for data entry. Then create a centralised report that pulls the data from all manager sheets. This could possibly be done with Power Query. 


@Ingeborg Hawighorst Thank You Ingeborg, I will give that a go.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies