Fix an Access-Exported Excel File Locked on a Shared Drive
Question details
An Excel workbook exported from Access appears locked for editing on a shared network drive, but works when saved to the desktop.

- Product
- Microsoft Access and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user exports an Access file to an Excel workbook on a shared network drive and wants to edit it.
- Observed behavior
- The exported workbook appears to be in use or locked on the shared drive even though no user is known to have it open. A copy saved to the desktop works correctly.
Note the exact lock message and the workbook's network path. Ask other users to close the workbook and confirm that the Access export has finished.
Close lingering Excel sessions and reopen the workbook
Use this method when a previous Excel session or another device may still hold the workbook open.
Ask anyone who may have opened the workbook from the shared folder to close it, including on other devices.
Save any open workbooks, then close all Excel windows on your computer.
On Windows, open Task Manager and look for remaining Microsoft Excel processes. After confirming there is no unsaved work, select a lingering Excel process and choose End task.
Open the workbook again from the shared network folder and check whether Excel allows editing.

Test the network drive and check for a stale file session
Use a standard Excel workbook to determine whether the lock affects the network location or only the Access export.
Edit Excel-Compatible Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and continue working with existing files as you move between office suites. Network locks and permissions still need to be resolved on the shared drive.

Frequently Asked Questions
Why does the workbook work on my desktop but not on the shared drive?
The shared drive may have an active file session or a permissions issue that does not affect the desktop copy. Test another workbook in the same shared folder and ask the network administrator to check the file session and folder permissions.
How can I check for an Excel process that did not close?
On Windows, open Task Manager and look for Microsoft Excel under Processes. Save any open work first, then select a lingering Excel process and choose End task.
What if a normal Excel workbook is also locked on the shared drive?
The issue may involve the shared folder rather than the Access export. Ask the network administrator to check your create, modify, and delete permissions and look for stale file sessions.
Can multiple people edit the workbook at the same time?
A standard network share may allow only one editor at a time. For Excel co-authoring, use a supported setup, such as a compatible workbook stored on OneDrive or SharePoint.




