'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Share an Excel File as Read-Only and Replace It in OneDrive
Question details
The user needs to share an Excel workbook with Mac users as read-only via OneDrive and replace it frequently without encountering file lock errors or users seeing outdated versions.
- Product
- Microsoft Excel / OneDrive
- Device & OS
- Mac
- Scenario
- Sharing a frequently updated Excel workbook with multiple users while preventing them from editing or locking the file.
- Observed behavior
- When the owner attempts to replace the file, OneDrive reports it as locked by other users, or users continue to see older versions after the replacement.
Ensure you have owner permissions to manage the sharing link settings on the OneDrive file, and notify your recipients that the file will be updated frequently.
Prevent File Locking by Setting View-Only Permissions
Changing the sharing link permissions to 'Can view' ensures that recipients cannot lock the file for editing, allowing the owner to overwrite it seamlessly.
When an Excel file is shared with 'Can edit' permissions, OneDrive automatically locks the file while users have it open to prevent conflicting changes. By restricting access to view-only, the file remains unlocked, allowing you to upload and replace the workbook at any time.
Open a web browser and navigate to OneDrive.com, then sign in to your Microsoft account.
Locate the Excel file you want to share, click the ellipsis (...) next to the file name, and select Share from the context menu.
In the sharing dialog, click on the current link permissions (e.g., 'Anyone with the link can edit') to open the link settings.
Under 'More settings', change the permission dropdown from 'Can edit' to 'Can view', then click Apply.
Copy the new view-only link and distribute it to your Mac users. View-only access will prevent them from locking the workbook.
Try WPS Office for Seamless Spreadsheet Management
If you frequently experience file locking issues or syncing delays with Microsoft Excel and OneDrive, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for creating, editing, and sharing your spreadsheets without the hassle.
Frequently Asked Questions
Why does OneDrive say my Excel file is locked for editing?
This occurs when a user accesses the file using a link that has 'Can edit' permissions. Excel locks the file to prevent conflicting changes, which stops you from being able to replace or overwrite the file from your end.
How do I force Mac users to see the updated Excel file?
Users who already have the file open in their browser or application must refresh the webpage or completely close and reopen the file to fetch the latest version you uploaded.
Can I overwrite a shared file without breaking the original link?
Yes, if you upload a new file with the exact same name and extension to the same folder in OneDrive, it will replace the existing file. The original sharing link will remain active and direct users to the newly updated version.
Will setting the file to read-only prevent users from downloading it?
No. By default, users with 'Can view' permissions can still download a local copy of the Excel file. If you want to prevent downloads entirely, you need to toggle the 'Block download' option in the OneDrive link settings.
