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
New Contributor

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

3 Replies

@nick-vaughan Any joy finding a solution? I would like to do something similar. Thank you, Tom

 

Hi Tom,

Unfortunately not sorry.

Bw,
Nick
Thanks for coming back to me.