File Sharing Problems

Fix Excel Co-Authoring Not Working on a Network Drive

Adam Davis Oct 9, 2026 871 views

Question details

The user wants to know if simultaneous real-time co-authoring is supported for Excel files stored on a traditional local or corporate network drive.

Can You Co-Author Excel Files on a Network Drive?

Product: Microsoft Excel
Device & OS: not provided
Scenario: Multiple users are attempting to collaborate and edit a shared Excel workbook hosted on a local or corporate network drive at the same time.
Observed behavior: Real-time co-authoring is unavailable on network drives; opening the file locks it for other users, forcing them to open a read-only copy.

Before you start

Verify your current Microsoft Office version and ensure you have an active Microsoft 365 subscription, as modern real-time co-authoring requires cloud-connected applications.

Solution 1Recommended

Migrate the Excel Workbook to SharePoint or OneDrive

To enable real-time co-authoring, you must host the Excel file on a supported Microsoft cloud service rather than a traditional network drive.

Native real-time co-authoring in Microsoft Excel is strictly designed to work with Microsoft's cloud infrastructure. Traditional network drives lack the synchronization protocols required to merge simultaneous changes in real time.

Open the file

Open the Excel workbook that is currently saved on your traditional network drive.

Access the Save As menu

Click on the 'File' tab in the top left corner of the Excel ribbon, then select 'Save As' from the left-hand menu.

Select a cloud location

Choose 'OneDrive - [Your Company]' or 'Sites - [Your Company]' (SharePoint) from the list of available save locations.

Save and share

Save the file to the cloud location, then click the 'Share' button in the top right corner of the Excel window to invite your colleagues to collaborate.

Migrate the Excel Workbook to SharePoint or OneDrive

Real-time sync enabled: Once moved to OneDrive or SharePoint, multiple users can edit the document simultaneously. You will see colored cursors indicating where others are currently typing.

Solution 2

Use the Legacy Shared Workbook Feature for Network Drives

If you are strictly limited to using a network drive, you can use Excel's older 'Shared Workbook' feature, though it lacks real-time co-authoring.

Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

Struggling with Excel network drive limitations? WPS Office offers a highly compatible alternative to Microsoft Office. With built-in WPS Cloud, you can easily share and co-author spreadsheets with your team in real time, avoiding the hassle of traditional local drive file-locking issues.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free built-in WPS Cloud storage for easy real-time document collaboration.Familiar tabbed user interface ensures a zero-learning-curve transition.Lightweight, fast installation suitable for older and modern computers alike.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file say 'Locked for editing' on a network drive?

On traditional network drives, Excel uses file locking to prevent conflicting changes. When one person opens the file, the operating system locks it for everyone else, meaning subsequent users can only open a read-only copy.

Can I use Google Drive or Dropbox for Excel real-time co-authoring?

No, native Excel real-time co-authoring within the desktop application only works with Microsoft's own cloud services (OneDrive and SharePoint). Third-party cloud providers generally require you to use Excel for the Web or their own proprietary spreadsheet tools for real-time collaboration.

How do I know if Excel co-authoring is actually working?

When co-authoring is active, you will see colored cursors with user names in the spreadsheet indicating where other participants are currently working. Additionally, their profile pictures or initials will appear in the top right corner of the Excel window.

Document & File Issues