File Sharing Problems

Fix an Access-Exported Excel File Locked on a Shared Drive

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

An Excel workbook exported from Access appears locked for editing on a shared network drive, but works when saved to the desktop.

Fix an Access-Exported Excel File Locked on a Shared Drive
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.
Before you start

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.

Solution 1Recommended

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.

1
Check other devices

Ask anyone who may have opened the workbook from the shared folder to close it, including on other devices.

2
Close Excel normally

Save any open workbooks, then close all Excel windows on your computer.

3
Check for remaining processes

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.

4
Reopen the shared file

Open the workbook again from the shared network folder and check whether Excel allows editing.

Close lingering Excel sessions and reopen the workbook
Editing on a network share: A standard network folder may allow only one person to edit a workbook at a time. Excel co-authoring requires a supported setup, such as a workbook stored on OneDrive or SharePoint.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLSX and XLS filesReview Access-exported Excel workbooks in WPS SpreadsheetsUse a familiar interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
QA img-9

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.