Excel with restricted access to different user

%3CLINGO-SUB%20id%3D%22lingo-sub-2743648%22%20slang%3D%22en-US%22%3EExcel%20with%20restricted%20access%20to%20different%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2743648%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20worksheet%20with%20different%20suppliers%20and%20their%20relevant%20inputs%20which%20needs%20to%20be%20keyed%20in%20by%20each%20and%20every%20supplier%20every%20week.%20I%20need%20to%20make%20sure%20that%20Supplier%20A%20can%20view%20only%20his%2Fher%20relevant%20details.%20when%20supplier%20B%20opens%20up%20the%20same%20worksheet%2C%20I%20need%20the%20restrict%20him%20to%20view%20only%20his%20relevant%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20restrict%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2743648%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%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%3CLINGO-SUB%20id%3D%22lingo-sub-2744057%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20with%20restricted%20access%20to%20different%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F887906%22%20target%3D%22_blank%22%3E%40Vignesh2112%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20think%20that's%20possible.%20More%20feasible%20solution%20of%20each%20supplier%20works%20with%20its%20own%20file%20and%20you%20combine%20them%20in%20one%20with%20Power%20Query%20or%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi 

I have an excel worksheet with different suppliers and their relevant inputs which needs to be keyed in by each and every supplier every week. I need to make sure that Supplier A can view only his/her relevant details. when supplier B opens up the same worksheet, I need the restrict him to view only his relevant data.

 

Is there a way to restrict this?

 

Thanks

1 Reply

@Vignesh2112 

I don't think that's possible. More feasible solution of each supplier works with its own file and you combine them in one with Power Query or like.