how to share excel file for multiple users office 365

For example, they could turn off tracked changes or unshare the workbook. When you use a normal shared workbook, other users may change the file's settings. Use the 'Protect and Share Workbook' feature (optional) From this tab, you can make changes or keep the default selections. This shows options for settings such as how often file changes update, how long you want to keep the change history or how you want Excel to handle conflicting changes. If you want to customize settings on your shared workbook, click the 'Advanced' tab in the Shared Workbook dialog box. Change settings under 'Advanced' (optional) This also allows workbook merging.' If the box has a check mark in it, then you've turned on the shared workbook feature. In the Shared Workbook dialog box, click the box next to 'Allow changes by more than one user at the same time. Then, click on the 'Shared Workbook' button. Once you've enabled the shared workbooks function, you should be able to find the button in the Quick Access Toolbar at the top of your screen. Using the same list, add 'Track Changes (Legacy)', 'Protect Sharing (Legacy)' and 'Compare and Merge Workbooks.' In the drop-down menu labeled 'Choose Commands From,' select 'All Commands.'įrom this list, select 'Shared Workbooks (Legacy)' and click 'Add.'

Select 'Quick Access Toolbar' in the left column of the Options dialog box. Follow these six steps for enabling shared workbooks:Ĭlick 'File' at the top left of your screen, then select 'Options' at the bottom of the left column. Before you can use it, return it to the Quick Access Toolbar of your spreadsheet. If you have Excel, you may have the shared workbooks feature hidden. Here are six steps you can follow when using the shared workbooks feature: 1. Related: 25 Best Excel Tips To Optimize Your Use How to share an Excel file Shared workbooks can also be unshared once you've completed the collaborative work. With this method, multiple people can edit an Excel file simultaneously, and the owner can accept or reject those changes. Shared workbooks are a method of sharing Excel files with other people who have access to the same local or shared network. In this article, we explain what shared workbooks are, how to use them, their benefits and limitations and other methods and tips for sharing Excel files. If your work involves a lot of spreadsheets and you need an easier way to collaborate, it's helpful to learn more about shared workbooks. One of these methods involves shared workbooks, an Excel feature that allows people to edit simultaneously. There are several options for easily sharing and working on an Excel file with a coworker.

How to share excel file for multiple users office 365