Shared Workbook vs Co-Authoring

Below details some main differences between a shared workbook versus co-authoring a file.

Microsoft has two ways to share files, Shared Workbook and Co-Authoring
Shared Workbook is now Legacy Feature which Microsoft hides by default
- https://support.microsoft.com/en-au/office/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6c259303fe05
To enable Shared Workbook the user must manually add it to the Quick Access Toolbar
- https://support.microsoft.com/en-au/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534
The only way to share a Shared Workbook file is to upload it to a server
- https://www.ablebits.com/office-addins-blog/excel-shared-workbook-multiple-users/
Co-Authoring is Microsoft’s new version of file sharing
To Co-Author a file the user can use the built in share feature of most Office Applications
- https://support.microsoft.com/en-us/office/document-collaboration-and-co-authoring-ee1509b4-1f6e-401e-b04a-782d26f564a4
Co-Authoring is better for in time collaboration since it shows changes in real time to all users
Shared Workbook works more as version control since it doesn’t update in real time, meaning that the user will have to deal with any conflicting changes
Since Shared Workbook is a Legacy Feature and isn’t as versatile as Co-Authoring, we recommend turning off Shared Workbook for all current files and moving them over to Co-Authoring
- https://support.microsoft.com/en-au/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534
- Scroll to the Additional Information Section for a guide to disable Shared Workbook