SOLVED

Excel with restricted access to different user

Copper 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
best response confirmed by Vignesh2112 (Copper Contributor)
Solution

@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.

1 best response

Accepted Solutions
best response confirmed by Vignesh2112 (Copper Contributor)
Solution

@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.

View solution in original post