Can You Co-Author an Excel File Stored on a Company Server?
Question details
The user wants to know if simultaneous editing is supported for Excel workbooks stored on a traditional company local server or mapped network drive.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users attempting to edit the same Excel file simultaneously over a local network.
- Observed behavior
- Users are trying to determine the required storage locations to enable co-authoring, as traditional network drives lock files for editing by a single user.
Check your file's current extension to ensure it is saved in a modern format like .xlsx or .xlsm, as older .xls files inherently block real-time collaboration regardless of where they are stored.
Move Your Excel Workbook to SharePoint or OneDrive
Traditional Windows file servers do not support modern Excel co-authoring. You must migrate the file to a cloud-based Microsoft 365 service to enable real-time collaboration.
Excel's real-time co-authoring feature relies on the synchronization engines built specifically into Microsoft 365 cloud services. A standard mapped network drive or local company server lacks these backend services, which means the file will be locked for editing by the first person who opens it.
Open your web browser, navigate to your company's SharePoint Document Library or your OneDrive for Business account, and upload the Excel workbook from your local server.
Select the newly uploaded file, click the 'Share' button, and invite your colleagues by entering their email addresses. Ensure you set their permission level to 'Can Edit'.
Have all users open the shared file using either Excel for the Web or the desktop Excel application (Microsoft 365 version). Verify that the 'AutoSave' toggle in the top-left corner of the Excel window is turned on.
Co-Author Spreadsheets Effortlessly with WPS Office
If your local company server restricts you from collaborating and setting up SharePoint is too complex, WPS Office provides a built-in, hassle-free solution. Using WPS Cloud, multiple team members can simultaneously edit spreadsheets in real-time.
- 1. Save to WPS Cloud: Open your spreadsheet in WPS Spreadsheet, click 'Save As', and select your WPS Cloud drive as the destination.
- 2. Share the Document: Click the 'Share' button in the top right corner to generate a secure sharing link or invite specific collaborators via email.
- 3. Co-Edit in Real-Time: Collaborators can open the link to view and edit the spreadsheet simultaneously, with all changes syncing instantly across devices.
Frequently Asked Questions
Why does my Excel file say 'locked for editing' on the network drive?
When a file is stored on a traditional company server or network drive, the server locks the file for the first person who opens it to prevent conflicting changes. Real-time co-authoring requires the synchronization capabilities found only in OneDrive or SharePoint.
Can I use the legacy 'Share Workbook' feature on a local server?
While older versions of Excel offered a 'Share Workbook (Legacy)' feature for local network drives, Microsoft has deprecated it because it frequently caused file corruption, data loss, and conflicts. It is highly recommended to transition to modern cloud-based co-authoring.
Does everyone need a Microsoft 365 subscription to co-author an Excel file?
To co-author using the desktop version of Excel, all users generally need an active Microsoft 365 subscription. However, users without a subscription can still participate in co-authoring for free by opening the shared file in Excel for the Web via their browser.
What file formats are supported for Excel co-authoring?
The workbook must be saved in the modern XML-based formats: .xlsx, .xlsm, or .xlsb. The older Excel 97-2003 format (.xls) and Strict Open XML Spreadsheet formats do not support simultaneous editing.
