how to share excel file for multiple users office 365

You can have different settings for different people. RowShare allows you to take control over the rows and columns you share.

You can use Excel together with RowShare, an online collaboration tool whose one of the strengths lies in its Access Rights. Is there any other way that is easier for me? Do It in RowShare So, this is not the best way to share your file with a lot of people. This method may take time, plus, the more people you need to share with, the more inconvenient it becomes. Note that you need to protect your file to prevent them from unhiding the hidden rows. Just follow these steps to do it:īut, if you don’t want every user to see the same rows, you will need to create one copy for each contributor as well. That way, the rows containing sensitive information will be hidden from the spreadsheet. Note that, if you expect these users to add information to their copies of your file, once they return it to you, you’ll have to copy/paste it the other way to consolidate everything in your master file.Įxcel offers the option to hide rows. 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.

How to share excel file for multiple users office 365