Excel File Open in Another Application Error: Fixes

If Excel says a file is open in another application, first close the workbook everywhere it may be in use, including other Excel windows, File Explorer previews, and other people’s sessions; then try opening it again. If the message remains, check for a leftover Excel process or a stale lock file, but do not delete a lock file until you have confirmed that nobody still has the workbook open.

The wording can vary, and the cause is not always another program in the ordinary sense. Excel may be reporting a file lock, a read-only state, a sync conflict, or a temporary problem accessing the folder. The safest fix depends on the exact message and where the workbook is stored.

What the error means

A workbook can be protected from simultaneous editing while Excel or another service is using it. A lock helps prevent two separate copies from saving over one another’s changes. The message may name another user, say that the file is locked for editing, or suggest that it is open in another application. Those descriptions can point to different situations, so note the full wording before changing anything.

For a file on your own computer, the most common explanation is that Excel still has a copy open, perhaps in a second window or a background process. A file preview, synchronization client, or another program may also have a handle on it. On a shared drive, a colleague may genuinely be editing the workbook, or a previous Excel session may have ended without clearing its lock.

A lock is not the same as a password or worksheet protection. A locked file may still open as read-only, while a password-protected workbook asks for a password. Do not remove protection or change file permissions just because Excel reports that another application is using the file.

Start with the safest checks

Before using Task Manager or deleting anything, check the straightforward causes. These steps preserve other people’s work and often resolve the issue immediately:

Look for another Excel window or workbook, including minimized windows. In Excel, use the View tab’s Switch Windows command if it is available, or inspect the taskbar.
Ask anyone who may use the file whether they have it open. This matters especially for workbooks on a network share or in a shared cloud folder.
Close the workbook in any other program that may have opened or previewed it, such as a file-management or document-management application.
Wait briefly if the file is being downloaded, uploaded, or synchronized. Check that OneDrive or another approved sync service reports that syncing has finished.
Try opening the workbook again from its folder, rather than from a recent-file shortcut that might point to a moved or renamed copy.

If you only need to read the data while someone else edits it, use the read-only option rather than trying to break the lock. In Excel for Microsoft 365 on Windows, select the file in the Open dialog and use the arrow beside the Open button to choose Open Read-Only, when that option is available. You can also ask the editor to share a copy or wait until editing is finished.

Close Excel and check for a background process

Excel may remain running after its visible window disappears, particularly if a prompt is hidden or an add-in has stalled. First save any work you can, close all Excel workbooks normally, and wait a few seconds. Then reopen Excel and test the file.

If Excel will not close normally, open Task Manager with Ctrl+Shift+Esc on Windows. Under Processes, look for Microsoft Excel. Before selecting End task, make sure there is no unsaved work in any workbook: force-quitting Excel can discard changes, and it does not provide a reliable opportunity to save. Ending an Excel process is a last resort, not a routine way to unlock files.

On a Mac, quit Excel with Command+Q after saving, then check Activity Monitor if Excel appears to remain active. Force Quit or ending a process can also lose unsaved changes. Excel for the web runs in a browser, so close the workbook tab only after considering whether edits have finished syncing; a browser tab is not the same as a local Excel process.

After a forced shutdown, reopen Excel and look for its Document Recovery pane. It may offer a recoverable version, but recovery is not guaranteed. Compare any recovered copy with the original before replacing or deleting files.

Check File Explorer previews and other applications

On Windows, File Explorer’s Preview pane can keep a workbook open for preview while you are trying to edit it. In File Explorer, open View and turn off Preview pane, then close the window displaying the file and try again. The exact View layout differs between Windows versions; in Windows 11, Preview pane is available from the View menu.

Also close any application that might be reading the workbook: a document-management tool, a data-import process, a backup utility, or a program that has loaded the file for analysis. A read operation does not always prevent Excel from opening a workbook, but another process can hold a file in a way that blocks Excel from obtaining the access it needs. If you cannot identify the application, restart Windows after saving work and confirming that other users are not editing the file.

Do not turn off antivirus or security software as a first troubleshooting step. Security products can inspect files, but disabling protection creates risk and may not solve the underlying issue. If the warning occurs repeatedly on a managed computer, ask your IT administrator to investigate the application or policy involved.

Understand lock files and when not to delete them

When an Excel workbook is open, Excel may create a small temporary owner or lock file in the same folder. For a workbook named Budget.xlsx, the companion file may have a name beginning with ~$, such as ~$Budget.xlsx. It can be hidden, so it may not appear in File Explorer’s default view. The lock file helps indicate that the workbook is in use; it is not a spare copy of the workbook.

Do not delete a ~$. file while the workbook is open for anyone. Removing an active lock can confuse the status of the workbook and may allow conflicting edits. First have every user close the workbook and confirm that no Excel process is still using it. If the lock remains after that, and you have permission to manage the folder, you can show hidden items in File Explorer and remove only the clearly matching stale lock file. Keep the actual .xlsx or .xlsm workbook untouched.

If the workbook is on a network share, a lock may persist because a remote session is still active or because the share has a connectivity problem. Ask the file owner or IT support to check who has the file open before removing anything. A user may have disconnected unexpectedly while their session or file handle remains on the server.

OneDrive, SharePoint, and coauthoring

Cloud storage changes how simultaneous editing works. When a supported workbook is stored in OneDrive or SharePoint and opened by people using compatible versions of Excel, coauthoring may allow them to work together. This is different from opening a local file on a traditional shared drive, where Excel may present a read-only or locked-for-editing message.

Check that the workbook has finished uploading and that everyone is opening the same cloud copy. A downloaded attachment, a file in a local Downloads folder, and the original in OneDrive can have identical names but are separate files. If a sync conflict has produced multiple copies, compare their contents and timestamps before deciding which one to keep; do not assume the newest-looking filename contains every person’s changes.

If a workbook is open in Excel for the web, another desktop session, or a phone app, close it from the application when possible and allow synchronization to complete. When the message names a person, contact them before taking action. If the lock appears incorrect after all users have closed the file and syncing has completed, a short wait, sign-out and sign-in, or help from the site or IT administrator may be needed.

When the file opens read-only or the warning continues

Read-only access can be a safe way to inspect a workbook, but it does not resolve the reason editing is blocked. Check the file’s location and permissions: you may lack write access to the folder, the file may have been marked read-only, or an administrator may control editing. On Windows, right-click the file, choose Properties, and review the Read-only attribute if you have authority to change it. Network and cloud permissions may need to be changed by the file owner instead.

If no one is editing and the error continues, work through these checks in order:

Confirm that the path points to the intended workbook and that the file is not in the middle of a sync or download.
Close Excel and other likely applications, then restart the computer if a file handle appears stuck.
Copy the workbook to a local folder you can write to and try opening that copy. Keep the original unchanged; this helps distinguish a folder or network issue from a problem with the workbook.
If the local copy opens, ask the folder owner or IT support to review access rights, server availability, and any file-management software.
If the local copy also fails, preserve a backup and note the exact error text. Excel’s Open and Repair option may help with a damaged workbook, but it addresses file damage, not a genuine active lock.

Do not overwrite the original with a copy simply because the copy opens. First establish which file contains the latest edits and whether other users have made changes. For important financial, operational, or regulated workbooks, follow your organization’s backup and incident procedures.

Prevent the error from coming back

Good file habits reduce both lock messages and the risk of losing edits. Use one agreed storage location for a shared workbook, avoid emailing separate versions around, and tell collaborators when you are finished editing. If several people need to work at once, store the workbook in OneDrive or SharePoint and use compatible Excel versions where coauthoring is supported.

Close workbooks before shutting down or disconnecting from a network. Give cloud sync time to finish, especially before turning off a laptop. Keep Excel and approved add-ins current, and report recurring locks to IT rather than repeatedly deleting temporary files. For a critical shared process, consider whether a workbook is the right collaboration tool; a database or managed list may handle simultaneous updates more reliably.

Frequently Asked Questions

Why does Excel say the file is open when I cannot see it?
Excel may still be running in the background, another user may have the workbook open, or File Explorer or another application may be holding it. Check other sessions and previews before ending a process or removing a lock file.

Can I delete the file that starts with ~$?
Only after confirming that every user has closed the workbook and no Excel process is using it. The file is a temporary lock or owner file, not the workbook itself. On a shared drive, ask the owner or IT support before removing it.

Will opening the workbook as read-only damage it?
No. Read-only access is intended to let you view a file without editing the original. However, it does not clear a lock or guarantee that you can save changes back to the same file.

How do I tell whether another person has the workbook open?
If Excel’s message names a user, contact that person. For a cloud workbook, check its sharing or activity information and ask collaborators. For a network share, an administrator may be able to inspect active sessions; do not assume a lock is stale just because no one responds immediately.

Does restarting the computer always fix the error?
No. Restarting can release a local process that has stopped responding, but it will not close another person’s session, fix missing folder permissions, or resolve a cloud sync conflict. Check the file’s location and users first.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.