Fix Excel for Mac Not Locking Files on AFP Network Shares
Question details
Users need a reliable way to prevent simultaneous editing overwrites because Excel for Mac does not display file-in-use warnings when workbooks are stored on an AFP network share.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Multiple users attempt to open and edit shared Excel workbooks stored on an Apple Filing Protocol (AFP) network drive.
- Observed behavior
- Excel fails to lock the file or display a read-only notification, allowing multiple users to edit the workbook simultaneously and overwrite each other's changes.
Ensure you have access to your organization's Microsoft 365 environment or administrative contact with your IT department to adjust network server settings.
Migrate to SharePoint Online or OneDrive for Business
Since Excel for Mac lacks built-in file-locking alerts for AFP shares, migrating your files to Microsoft's native cloud storage enables reliable co-authoring and manual Check Out features.
Using SharePoint Online or OneDrive for Business bypasses local network protocol limitations. It allows users to either safely co-author in real-time or explicitly lock files using the Check Out feature.
Sign in to your Microsoft 365 account and upload your Excel workbook to a SharePoint Document Library or OneDrive for Business folder.
Hover over the uploaded Excel file, click the three-dot (ellipsis) menu icon next to the file name, and select 'More'.
Click 'Check Out' from the dropdown menu. This grants you exclusive editing rights. Other users will now be notified that the file is locked and can only open it in view-only mode.
Once your edits are complete, return to the same menu and select 'Check In' to unlock the file for your colleagues.
Switch from AFP to SMB Protocol
If cloud migration is not an option, switching your server's file sharing protocol from AFP to SMB can improve compatibility with Office file-locking mechanisms.
Try WPS Office for Seamless Cross-Platform Collaboration
If network limitations and file-locking errors in Microsoft Office are slowing down your team, consider switching to WPS Office. It provides a highly compatible, free alternative for Mac users, complete with reliable built-in cloud collaboration tools that prevent version conflicts.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for macOS.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files with full formatting intact.
- 3. Collaborate Securely: Save your files to WPS Cloud to instantly share links with your team and collaborate without worrying about network share file-locking issues.
Frequently Asked Questions
Why doesn't Excel for Mac warn me when a file is open on an AFP share?
Excel for Mac relies on specific server-side protocols to trigger the 'file in use' warning. The Apple Filing Protocol (AFP) often fails to communicate the presence of temporary lock files back to the Excel application, resulting in no warning being displayed.
Can I recover an Excel file that was overwritten on a local network share?
If your network drive does not have volume shadow copies or an automated server backup system enabled, overwritten changes are usually permanent. This is why migrating to cloud storage with built-in version history is highly recommended.
Is Apple still supporting AFP for file sharing?
Apple has deprecated AFP in favor of SMB (Server Message Block) for file sharing in recent versions of macOS. Switching your network drives from AFP to SMB can improve performance and application compatibility.
