Restrict view access to sheet for certain users

%3CLINGO-SUB%20id%3D%22lingo-sub-1798415%22%20slang%3D%22en-US%22%3ERestrict%20view%20access%20to%20sheet%20for%20certain%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1798415%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20an%20Excel%20Online%20Document%20in%20Microsoft%20Teams%20which%20has%20a%20lot%20of%20information%20in%20a%20table%20on%20one%20worksheet%20that%20is%20a%20reference%20for%20quite%20a%20few%20people%20(about%20100).%26nbsp%3B%20However%20we%20would%20like%20to%20be%20able%20to%20provide%20the%20minimum%20information%20possible%20to%20different%20sets%20of%20people.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%20we%20would%20like%20to%20be%20able%20to%20have%201%20master%20excel%20document%20that%20only%2010%20people%20have%20read%2Fwrite%20access%20to%20and%20no-one%20else%20can.%26nbsp%3B%20Then%20have%20multiple%20other%20excel%20documents%20(read%20only)%20that%20references%20the%20master%20excel%20Spreadsheet%20that%20only%20shows%20certain%20columns%20for%20everyone%20else.%26nbsp%3B%20Is%20it%20possible%20that%20when%20people%20open%20one%20of%20the%20cut%20down%20excel%20documents%20the%20data%20will%20update%20from%20the%20Master%20excel%20spreadsheet%20even%20though%20they%20don't%20have%20read%20access%20to%20that%20master%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ENick%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1798415%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

Good Morning,

 

We have an Excel Online Document in Microsoft Teams which has a lot of information in a table on one worksheet that is a reference for quite a few people (about 100).  However we would like to be able to provide the minimum information possible to different sets of people.

 

Therefore we would like to be able to have 1 master excel document that only 10 people have read/write access to and no-one else can.  Then have multiple other excel documents (read only) that references the master excel Spreadsheet that only shows certain columns for everyone else.  Is it possible that when people open one of the cut down excel documents the data will update from the Master excel spreadsheet even though they don't have read access to that master document?

 

Thanks in advance.

 

Thanks,

Nick

0 Replies