If you decide to use the cloud, it means that you have to save those files separately and share a different link with each person. To share your workbooks, you can either use email, or the cloud. So, at the end you will have several files, one for each person. Share that new workbook instead of the master that has all information in it. Every time you need to share some information to different people, copy certain rows corresponding to that certain person, and paste it in a new file. You are the only person having the access to that workbook. In this case, one master where you record the columns containing sensitive information such as your students’ grades or employees’ salary. The simplest way to do in Excel is by having several workbooks. Share Your Excel Spreadsheet, Different Data, Different People A Different Link for Each Person If that’s the case, then each row must correspond to a single person. So, you want to share your Excel fie in a way that each student can only see their own grade. You don’t want each student to see other students’ grades. Say you are a teacher who records student grades in Excel, where you have a column containing all the grades. Then, we will see how RowShare, an online collaboration tool, can complement Excel in maximizing your sharing scenario. Do you sometimes wonder how to share an excel file with different people? Perhaps each row in your excel file contains sensitive information, so you want each person to see only certain row that concerns them? We will see here how to make an excel file shared smartly.
0 kommentar(er)
