Summary

This guide helps you troubleshoot and resolve: Document collaboration issues. Follow the steps below to fix the issue.

Common Causes

Problem

You’re having trouble collaborating on documents with colleagues — files won’t open, edits aren’t syncing, or you can’t see others’ changes.

Common Issues

• “File is locked for editing” by another user
• Can’t see other people’s edits
• Document won’t open or is corrupted
• Version conflicts when multiple people edit

Solutions

Problem 1: File Locked for Editing

Someone else has the file open

1. In Excel or Word, try opening the file.
2. If it says “[User] is editing this”, wait for them to close it.
3. Or ask the user to close the file.

Break the lock (admin only)

• Contact IT to release the lock.

SharePoint check‑out / check‑in

When a file is checked out, it is locked for other users.

1. In the SharePoint library, locate the file.
2. Click the ellipsis (…) > Check out to see its status.
3. To discard a checkout, select Discard check out. This releases the lock.

Problem 2: Can’t See Others’ Edits

Check you’re online

1. Ensure you have an active internet connection.
2. For OneDrive files, verify the sync status (green check‑mark). See OneDrive not syncing for troubleshooting.
3. Save the file (Ctrl + S on Windows, Cmd + S on macOS) to trigger a sync.
4. Refresh the document or close and reopen it.
5. Check that OneDrive isn’t paused and that you haven’t exceeded your storage quota.

Use the web version

1. Go to office.com or the relevant SharePoint site.
2. Open the document in the browser.
3. Changes sync in real‑time with others.

Offline editing conflicts

If you edit a file while offline, changes may conflict when you reconnect.

1. Before editing, ensure the file is fully synced.
2. After reconnecting, let OneDrive sync the latest version before making changes.
3. If a conflict occurs, follow the version‑conflict steps below.

Problem 3: Version Conflicts

Multiple people saved changes

If prompted about “conflicting copies”, choose one of the following:

• Keep my version — retain your changes.
• Keep their version — accept the other user’s changes.
• Keep both — creates a separate copy for manual merging.

Resolve manually

1. In SharePoint or OneDrive, right‑click the file and select “Version history”.
2. Compare the versions.
3. Restore the desired version or merge the changes. See File version history/recovery for details.

Problem 4: Can’t Open a Shared Document

Check permissions

1. The file owner must share the file with edit access.
2. Ask the owner to:
   • Right‑click the file in OneDrive.
   • Select “Manage access”.
   • Ensure your name is listed with edit permission.

Clear browser cache

1. If accessing via SharePoint, clear the browser cache.
2. Try an incognito/private browsing window.
3. Try a different browser.

Problem 5: OneDrive/SharePoint Sync Issues

Restart sync

1. Right‑click the OneDrive icon in the taskbar and select “Close OneDrive”.
2. Reopen OneDrive.
3. Wait for sync to complete.

Unlink and relink

1. Open OneDrive settings → Account → “Unlink this PC”.
2. Sign in again.
3. Choose the folders to sync and let OneDrive resynchronise.

File size limits

OneDrive for Business supports files up to 250 GB. Exceeding this limit can prevent sync and cause lock‑out situations.

Office Upload Center deprecation

The Office Upload Center is retired. To clear the Office document cache:

1. Open any Microsoft 365 desktop app (for example, Word or Excel).
2. Select File then Options.
3. Choose Save from the left‑hand menu.
4. Under Offline document caching, select Delete cached files.
5. Alternatively, close all Office apps and delete the contents of %localappdata%\Microsoft\Office\16.0\OfficeFileCache.

Problem 6: Document Is Corrupted

Try recovery

1. In Word or Excel, go to File → Info → Manage Document → Recover Unsaved Documents.
2. Look for AutoRecover files (default location: %appdata%\Microsoft\Office\UnsavedFiles).

Check version history

1. Right‑click the file and select “Version history” in OneDrive.
2. Restore a previous working version. See File version history/recovery for guidance.

Problem 7: Co-authoring Not Working in Desktop Apps

Verify Microsoft 365 licence and version

1. Ensure your device has an active Microsoft 365 licence.
2. Open any Office app, select File > Account, and check that you are signed in with the correct organisational account.
3. Select Update Options > Update Now to ensure you are running the latest version of Office.

Enable co-authoring in SharePoint

1. Open the SharePoint document library in a browser.
2. Select the file and open it in the desktop app.
3. Confirm the file is saved in a SharePoint library or OneDrive for Business location, not on a local drive.
4. Ask all collaborators to open the same file from the shared location rather than emailing copies.

Problem 8: “Edit in Browser” Option Missing

Open document from SharePoint or OneDrive

1. Navigate to the SharePoint site or OneDrive folder containing the document.
2. Click the file name to open it.
3. If the file opens in the desktop app, select Edit in Browser from the top menu bar.
4. If the option is missing, confirm you have edit permissions for the document library.

Check file type support

1. Ensure the file type supports browser editing (for example, .docx, .xlsx, .pptx).
2. Older formats such as .doc or .xls may not offer the “Edit in Browser” option.
3. Convert older files to the modern Office format before attempting browser editing.

Problem 9: SharePoint Check-out Requiring Major Version Settings

Configure major version requirements

1. Navigate to the SharePoint document library.
2. Select the settings gear icon and choose Library settings.
3. Under General Settings, select Versioning settings.
4. Set Require documents to be checked out before they can be edited? to No if you want to allow co-authoring without mandatory check-out.
5. Ensure Create major versions is selected and specify the number of major versions to retain.
6. Select OK to save the changes.

Best Practices for Collaboration

1. Use the browser or desktop app together: Real‑time collaboration works best in office.com or Microsoft Teams.
2. Tell others when you’re editing: Use comments or Teams to coordinate.
3. Save frequently: Press Ctrl + S (Windows) or Cmd + S (macOS) regularly to ensure changes sync.
4. Avoid editing the same section: Divide work by sections or pages.
5. Use comments instead of direct edits: For feedback, use track changes or comments.
6. Monitor file size limits: Keep files under 250 GB for OneDrive for Business and respect SharePoint library limits.
7. Clear Office cache regularly: Use Office app settings to delete cached files and prevent stale lock files.

Where to Store Collaboration Files

• OneDrive for Business – personal files you need to share.
• SharePoint – team or organisational files.
• Teams – chat and meeting files.
• Never store in local‑only folders.

Need More Help?

Open a ticket with IT Support if:

• Files consistently won’t open.
• Permission issues persist. See Cannot access shared network drives.
• You need a file forcibly closed.
• Document corruption issues occur.
• You experience frequent Office app crashes. See Excel/Word crashing.

Open a Ticket

Still Having Issues?