olzillinois.blogg.se

and click OK.Īny changes made to the workbook are then shown by small triangles in the top left-hand corner of the amended cell. In the Quick Access Toolbar, select Track Changes > Highlight Changes.Tracking changes in Excel also shares the workbook, if it is not already shared. Check Use the old shared workbooks feature instead of the new co-authoring experience.To share the current workbook, click on the Share Workbook icon.The icons are added to the Quick Access Toolbar in the title bar. Scroll through the list and add Track Changes (Legacy), Protect Sharing (Legacy), and Compare and Merge Workbooks.Then click Add > to add it to the Quick Access Toolbar. Scroll down and select Share Workbook (Legacy).In the Choose commands from drop-down list select All Commands.In the Ribbon, select File > Options > Quick Access Toolbar.In Office 365, you must enable the sharing of workbooks before you can share the workbook. Instead there is a share option in the top right-hand corner of the screen which allows the user to save the workbook to OneDrive and send a co-authoring link to another user. For this reason in Office 365, the traditional share feature has been hidden by default. In Office 365, Microsoft encourages users to use OneDrive and allow co-authoring of workbooks on the web. This tutorial demonstrates how to make a shared spreadsheet for multiple users in Excel and Google Sheets.ĭepending on the version of Excel, users can either share a workbook, or allow co-authoring.