how to work on excel sheet with multiple users

An alternative to AutoSave is constant refreshing or a comprehensive back-up policy. However, if you are working in a strategic Excel file with AutoSave 'on,' you cannot reverse changes (made by accident or on purpose) after saving.

At first, that doesn't seem like a big issue. To make changes visible for everyone simultaneously, you need to switch on AutoSave (in the left upper corner of your screen). Think twice about AutoSaveĪnother small issue that can have a considerable impact is AutoSave. By the way, one of these features is change tracking. Also, if someone adds a feature that is not supported, the co-authoring feature will not work either, and the file appears locked. At one point, this can be too much, and the file is marked as locked. This is something to consider as many of us access the same file from various sources like OneDrive explorer, a share link in Teams, or email. If you access the file in too many different ways, the co-authoring feature might not work. Sometimes a shared Excel workbook is suddenly marked as locked. How to use Excel co-authoring successfully in everyday business Don't 'over-do' the Excel workbook Let's dive into day-to-day requirements to make co-authoring work.

So co-authoring is worth the while if only for this. It is most annoying when you try to work in a spreadsheet and find it locked for editing because someone else is working on it (or forgot to close it and went out for lunch). If opened via the link, changes are highlighted in the same way, which is a big comfort win. You'll see changes made in different colors.Īnother scenario is sharing a link to your Excel file and asking everyone on your list to input or review values. Everyone can open an Excel workbook simultaneously and show or edit content.

The ideal scenario for Excel co-authoring is a Microsoft Teams Meeting. Comments and notifications (with are advisable.Ĭo-authoring in Excel is a feature mainly for real-time or live collaboration.Excel will save all changes made nonetheless, but they are harder to track.See each other's changes in a matter of seconds (in different colors depending on your Excel version.).Open a file simultaneously in editing mode.Here is what Excel co-authoring can do for you: If you open the Excel workbook with a share link, you can edit it no matter how many people are working on it at the same time. If you make your changes now, you cannot save them unless you keep a copy. In a world without co-authoring, you'll open your file from the shared folder only to find it locked because someone else is using it. Microsoft defines its co-authoring feature like this: 'Co-authoring means you and any number of people from your organization can open and work on the same Excel workbook.'Īnd Excel co-authoring makes a big difference in business, mainly when co-working in a heavily used Excel spreadsheet.

How to work on excel sheet with multiple users