All that has now changed.
I can finally stop using Excel Shared workbooks and enjoy the benefits of co-authoring with the introduction of Show Changes. Working on an Excel file stored in SharePoint or OneDrive with AutoSave on will now track changes. Open the file using a version that supports co-authoring; Excel app for Microsoft 365, Excel for the web or the Excel mobile apps. All your changes and everyone else that works on the file will be listed in the Changes pane.
To see changes made in the past 60 days, you currently must open the Excel file using Excel for the web. From the Show Changes pane, you can change the view to be a range or sheet.
I encourage you to check out Show Changes using the workbook on our SharePoint site, “Paper Printing & Management Analysis”.
There are, of course, some things that Show Changes does not currently track.
- Chart, shape, and other object edits
- Operations with PivotTable
- Changes to formatting
- Filtering and hiding cells or ranges and
- Deleted location
Some actions, including editing with a perpetual license or older version of excel, or uploading, saved copy or replaced file, will result in the changes being cleared.
Co-Authoring is now complete with Show Changes. A significant improvement to the collaboration experience. Work from any device, simultaneously with others and track the changes each person is making.
Enjoy collaborating with confidence.