How to Prevent Duplicate Copies of Shared Excel Files
Question details
Users need to prevent the creation of duplicate versions and version conflicts when multiple people edit a shared Excel workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating with multiple users on a single shared Excel workbook.
- Observed behavior
- Instead of collaborating in real-time on one file, users are inadvertently editing separate downloaded copies, leading to conflicting changes and duplicated files.
Ensure that all collaborators have an active internet connection and are signed into their respective Microsoft or OneDrive accounts before opening the shared file.
Enable Co-authoring via OneDrive or SharePoint
Storing your workbook on a cloud service like OneDrive or SharePoint enables real-time co-authoring, preventing duplicate file creation.
Co-authoring allows multiple users to edit the same Excel workbook simultaneously. This feature requires the file to be hosted on Microsoft's cloud services and saved in a modern file format.
Open the Excel file, go to 'File' > 'Save As', and select your OneDrive or SharePoint location.
Verify that the file is saved as an .xlsx, .xlsm, or .xlsb format, as older .xls formats do not support co-authoring.
Click the 'Share' button in the top right corner of Excel and send a sharing link to collaborators instead of attaching the file directly to an email.
Remind your team to click the shared link to open the file in Excel for the Web or their Microsoft 365 desktop app rather than downloading it locally to their computers.
Update and Configure the OneDrive Sync Client
Outdated OneDrive clients or sync errors can cause local copies to fork into duplicates.
Collaborate in Real-Time with WPS Office
WPS Office offers seamless real-time collaboration through WPS Cloud, ensuring you and your team can work on the same spreadsheet without creating duplicate versions or sync conflicts.
- 1. Save to Cloud: Open your spreadsheet in WPS Office and save it directly to WPS Cloud using the Save menu.
- 2. Generate Share Link: Click the 'Share' button located at the top right of the application window.
- 3. Adjust Permissions: Set the sharing permission to 'Anyone with the link can edit' and copy the generated link.
- 4. Collaborate Instantly: Send the link to your team members so they can instantly join the session and edit the same file simultaneously.
Frequently Asked Questions
Why does Excel say my shared file is locked for editing?
This typically occurs if the file is not stored on OneDrive or SharePoint, or if a collaborator has opened the file in an older version of Excel that does not support real-time co-authoring.
Can I co-author an Excel file that contains macros?
Yes, you can co-author macro-enabled workbooks (.xlsm) provided you are using a compatible Microsoft 365 subscription and the file is securely stored on OneDrive or SharePoint.
How do I stop OneDrive from creating files with my computer name added to them?
These are synchronization conflict files. Ensure your OneDrive client is up to date, avoid editing files offline for extended periods, and make sure the 'Use Office applications to sync Office files that I open' setting is enabled in your OneDrive settings.
Do all users need a Microsoft account to edit a shared Excel file?
If you share the file using an 'Anyone with the link' setting, users can edit as guests without needing an account. However, requiring a sign-in helps you track exactly who is making specific changes.
