Opening a document at the same time as a coworker, leaving comments, watching changes appear live: that’s the promise of co-editing in Microsoft 365. But in practice, it rarely feels that smooth. Most teams are still stuck with the same daily headaches: duplicate files, Excel filters that shift the screen for everyone, Word paragraphs that lock up, or access denied on files people actually need.
Yet none of that comes from the tool itself. It comes down to a handful of habits and settings most teams have never had explained to them. As a Microsoft Partner, we run into these exact roadblocks every day. Here’s how to fix the habits that are slowing your team down.
Stop sharing from your personal OneDrive
Real-time co-editing only works well when you follow one basic rule: stop saving files straight to your computer or your personal OneDrive. Any document meant for more than one person long-term should live in a SharePoint library for the relevant team.
This solves two problems at once. File access and ownership no longer sit with a single person, so nobody gets stuck in “view only” mode, and nothing gets permanently lost if that person leaves the company.
Not sure what the difference between OneDrive and SharePoint even is? You’re not alone. We wrote a whole article on it right here 😉.
Don’t let co-editing wreck your Excel sheets
Excel is where co-editing can turn chaotic fastest if you’re not paying attention.
- The one-cell rule: Working together on a large spreadsheet is great, but please watch your cursor as two people can’t edit the same cell at the same time. If you type where a coworker is already typing (or leave your cursor sitting in their cell while you grab coffee), your changes might simply fail to save.
- Sheet views: When you filter or sort a shared spreadsheet, that view changes on everyone’s screen, not just yours. So while you’re digging through the data, a coworker might see half their rows vanish with no idea why. Sheet Views fixes this: go to the Data tab, then Sheet Views, then New, and you get your own private view to sort and filter without affecting anyone else. Full details here.
Avoid mix-ups when collaborating in Word
Writing a document as a group can get frustrating fast if people start erasing each other’s work without a trace.
- Turn on Track Changes: Don’t type over a coworker’s text without leaving a record. Turn on tracking from the ‘’Review tab’’, and your edits stay visible as suggestions. The document owner can then accept or reject them, so good ideas don’t get lost along the way.
- Respect the paragraph lock: The moment you start typing in a paragraph, Word temporarily locks that section for everyone else to prevent collisions. If you see a coworker’s name pop up next to a line, wait until they move on before touching that text.
Avoid visual conflicts in PowerPoint
- Don’t move slides on the fly: Reordering pages or deleting a section while a coworker is adding content to it will throw off the sync entirely. Assign clear slide numbers upfront so nobody’s stepping on anyone else’s work.
- Don’t touch the Slide Master: Changing the official fonts or colors while a coworker is adding content can break their entire layout in real time. Lock down the visual style before opening the file up to editors.
- Bonus tip: Once co-editing wraps up, if you need to present the deck as a team on a Teams call, skip the plain screen share. Use PowerPoint Live in Teams instead. It lets multiple people co-present and take turns controlling the slides, without ever having to hand off the call.
Better collaboration starts with the right setup
Microsoft 365 co-editing is a great tool, but it won’t fix everything on its own. If your team is still losing time to locked files or denied access, the root cause is usually the initial setup or the habits people have built around it.
At S3, we believe IT infrastructure only really works when employees feel comfortable using it day to day. That’s why this kind of guidance is always part of how we work with our clients.
Want an IT partner who thinks beyond basic support tickets? Get in touch and let’s talk.
