Fix the Microsoft Excel cannot access the file error by correcting the workbook’s filename and path, closing copies that hold a lock, and opening a copy from an accessible local folder. If the workbook opens but will not save, save a separate copy under a different name. Choose subsequent fixes based on whether Excel reports a permission problem, security restriction, or damaged workbook.
These desktop steps cover Excel for Microsoft 365 and Excel 2024, with Mac instructions identified separately. Windows instructions use Windows 11 menus. Check the file and its location before changing Excel settings or repairing Office.
The short version
- Check the path: On Windows, remove unsupported characters and keep the complete path within 218 characters.
- Try another location: Open a local copy or save a separate copy to another accessible folder.
- Release locks: Close the workbook on your other devices and wait a few minutes.
- Match the symptom: Use permission, repair, or Safe Mode steps only when they fit the failure.
| Fix | When to use it |
|---|---|
| Remove unsupported characters | The filename or a parent folder contains problematic characters |
| Shorten and verify the path | The folder cannot be found or the full path exceeds 218 characters |
| Open a local copy | The workbook is on a network or external drive |
| Download the OneDrive workbook | You need an online-only file offline |
| Release the workbook lock | Excel reports that the file is locked |
| Request editing access | A shared workbook is view-only |
| Save under a different name | The workbook opens but cannot be saved |
| Check destination permissions and space | Saving fails in a particular folder |
| Save in another Excel format | The workbook remains open and can be saved separately |
| Allow Mac folder access | macOS privacy controls block the location |
| Correct Mac filesystem permissions | Your account cannot read or write the item |
| Allow Excel through Controlled folder access | Windows displays an Excel blocking notification |
| Exit Protected View | A trusted workbook has a security bar |
| Review File Block settings | Excel explicitly blocks an older format |
| Repair the workbook | You suspect file corruption |
| Extract values and formulas | Workbook repair fails |
| Try manual calculation | Corruption or calculation prevents opening |
| Restore an earlier cloud version | A suitable version is available in OneDrive history |
| Start Excel in Safe Mode | Add-ins or startup customization may interfere |
| Disable conflicting add-ins individually | The workbook works in Safe Mode |
| Update Excel on Windows | You need current Office application fixes |
| Update through Microsoft AutoUpdate | Your Mac installation came from Microsoft |
| Update through the Mac App Store | Your Microsoft 365 Excel installation came from the App Store |
| Restart Excel or repair Office | Application failures continue after file checks |
| Correct the Windows file association | Double-clicking opens the wrong application |
| Unhide or refresh the workbook window | Excel opens a blank window without an access error |
| Review the DDE setting | Another application passes the opening request to Excel |
| Clear the Office document cache | A cloud-document cache problem persists |
| Revert to the last saved state | Corruption began during the current editing session |
Check the workbook name and full path
In Excel for Microsoft 365 or Excel 2024 for Windows, unsupported characters in either the filename or a parent folder can prevent access. Open File Explorer and locate the actual workbook, confirming that its containing folder still exists. Rename the workbook and affected folders to remove [ ] ? < > : | *, while preserving the workbook’s extension.
Check the complete path, including the folder names and filename. Keep it within 218 characters by shortening the filename or moving the workbook into a shallower folder, then reopen it from that location. Microsoft recommends renaming affected files and folders rather than relying on Excel’s Open command to get around unsupported characters.
Try an accessible local copy
For a Windows workbook stored on a network or external drive, copy it to an accessible local disk and open that copy. If the workbook is already open, select File > Save As to save it to another location. This helps isolate storage, network, and location-permission problems.
An online-only OneDrive workbook needs to download before you can use it offline. While connected to the internet and signed in to OneDrive on Windows, right-click the workbook in File Explorer and select Always keep on this device. Wait for the download to finish, then open the file.
If the local copy opens, focus on access to the original location. If it still fails, follow the fix that matches Excel’s message. A locked-file warning calls for releasing the lock, while a save-only failure calls for testing another filename or destination.
Release file locks and request editing access
When Excel says the workbook is locked for editing, close it on every device where you have it open, including another Windows PC or Mac. Wait a few minutes before reopening it. If another person holds the lock, ask them to close or check in the workbook, or open it read-only when you only need to view its contents.
For a shared, view-only workbook in an Excel build with Request more access, select Viewing > Request more access. Choose Ask to edit or Ask to review, add an optional note, and send the request to the owner. If that control is missing, ask the owner directly for the access you need.
Save a separate copy when saving fails
If your workbook opens but refuses to save in Excel for Microsoft 365 or Excel 2024 for Windows, select File > Save As. Enter a unique filename and save a separate copy. Try another accessible location if the original folder still fails.
To test the destination itself, create a blank workbook and try saving it to the affected folder through File > Save As. The destination needs sufficient available space and read, write, modify, and delete permissions. If space is insufficient, choose another disk; if permissions are missing, ask the folder’s owner or administrator to grant them.
Saving a workbook containing VBA as .xlsx loses that VBA, so choose .xlsm to preserve it. To try another appropriate Excel format, select File > Save As, choose the format under Save as Type, and save a separate copy. Keep the original workbook while you check whether the separate copy saves successfully.
Correct folder access on your Mac
For Excel for Microsoft 365 for Mac or Excel 2024 for Mac, check these permissions when macOS denies access to the workbook’s location. On a macOS version using System Settings, open the Apple menu > System Settings > Privacy & Security > Files & Folders. Find Microsoft Excel and turn on access for the affected location when it is listed.
If the location is not listed, or access still fails, check the file’s filesystem permissions. In Finder, select the workbook or containing folder, then choose File > Get Info. Expand Sharing & Permissions, unlock the settings, select your account, and give it permission to read and write the item.
You need ownership or administrator authority to change those permissions. If you cannot change them, ask the owner or administrator to correct access.
Respond to the specific security block
On Windows 11, use the Controlled folder access fix only when Windows displays an App is blocked notification for Excel. Note the executable’s path, select the notification, then select Add an allowed app. Browse to the verified Excel executable and retry saving. On a managed device, ask your administrator to handle the exception if policy controls access.
In Excel for Microsoft 365 and Excel 2024 for Windows, Protected View restricts editing of an opened workbook. For an individually trusted file with a yellow security bar, select Enable Editing; for the red-bar case, select File > Edit Anyway. If policy prevents this, contact your administrator. These steps address Protected View restrictions, not missing files or filesystem permissions.
For an explicit File Block error involving an older format in these Windows editions, open File > Options > Trust Center > Trust Center Settings > File Block Settings. Locate the affected format, then uncheck Open to permit opening or Save to permit saving. Restrictions enforced by an administrator require that administrator’s action.
Repair a damaged workbook or recover an earlier version
If your workbook may be damaged, work on a copy when possible. In Excel for Microsoft 365 or Excel 2024 for Windows, select File > Open and locate the workbook. Select it in the file dialog, open the arrow beside Open, and choose Open and Repair > Repair.
When repair cannot recover the workbook, repeat Open and Repair and choose Extract Data. This attempts to recover values and formulas rather than restore the complete workbook with full fidelity.
For damage or calculation-related opening failures, try opening without automatic recalculation. Create a Blank workbook through File > New, then select File > Options > Formulas. Under Calculation options, choose Manual, select OK, and retry the damaged workbook through File > Open.
Restoring an earlier OneDrive version replaces the current version with the selected earlier one. For a synced OneDrive workbook with version history available, right-click the file in Windows File Explorer and select Version history. Beside a suitable earlier version, select ... > Restore. You can also right-click the workbook on OneDrive’s website and follow the same workflow.
Test Excel Safe Mode and add-ins
Excel’s application Safe Mode helps isolate interference from add-ins and startup customization in Excel for Microsoft 365 and Excel 2024 for Windows. Press Windows + R and enter this command:
excel /safeSelect OK, then retry opening or saving the workbook. If it works in Safe Mode, check installed add-ins individually to identify a possible conflict.
Open File > Options > Add-Ins. Under Manage, choose COM Add-Ins and select Go, then uncheck one installed add-in, select OK, and restart Excel. Repeat individually, then test Excel Add-Ins through the same Manage control.
Update Excel and repair Office
Restart Excel first if you have not already done so. To update Microsoft 365 Apps or Office 2024 on Windows, open Excel or another Office application and select File > Account > Update Options > Update Now. Select Enable Updates first when necessary. If updates are managed and Update Options is missing, contact your administrator.
For Excel installed from Microsoft on a Mac, select Help > Check for Updates, then select Update or the Update button beside Excel in the expanded list. For Microsoft 365 Excel installed through the Mac App Store, open the App Store, select Updates, and select Update beside Excel.
If failures continue with a Microsoft 365 or Office 2024 Click-to-Run installation on Windows 11, right-click Start and select Installed apps. Find Microsoft 365 or Office, select ... > Modify, then choose Quick Repair and select Repair. If that does not resolve the problem, return and choose Online Repair, then select Repair. Microsoft describes Online Repair as the more comprehensive option, and repairing Office affects the installed suite.
Frequently Asked Questions
What if double-clicking the workbook opens the wrong application?
On Windows 11 with desktop Excel installed, right-click the workbook and select Properties > General > Change, then select Excel. Use More apps if necessary, select Always use this app when that control is displayed, and select OK. The dialog layout can vary by Windows build.
What should you do if Excel opens a blank window instead of showing an access error?
In Excel for Microsoft 365 or Excel 2024 for Windows, select View > Unhide, choose the workbook, and select OK. You can also minimize Excel and restore its window. Use these steps for a blank-window symptom rather than an access-error dialog.
Can the DDE setting help with this error?
The DDE setting is relevant when another application passes an opening request to Excel for Microsoft 365 or Excel 2024 for Windows. Open File > Options > Advanced and, under General, uncheck Ignore other applications that use Dynamic Data Exchange (DDE). Treat this as a check for that opening scenario, not a general fix for every file-access error.
Should you manually delete the Office file cache?
Microsoft discourages manually deleting the OfficeFileCache folder because of crash and data-loss risks. Deleting cached files removes cached document copies, so preserve unsynced work first. For cloud-document cache problems in Windows Office builds exposing the control, select File > Options > Save > Cache Settings > Delete cached files. Version 2512 and later may also offer to remove pending uploads; this discards their pending changes, so select Delete only if you can safely discard them.
How can you undo corruption introduced during the current editing session?
Reverting the open workbook to its last saved state discards unsaved changes. In Excel for Microsoft 365 or Excel 2024 for Windows, select File > Open, double-click the current workbook, and select Yes. Use this when you want to recover the saved version.
Does the old Mac Grant Access workaround still apply?
Microsoft fixed the historical unexpected Grant Access prompt and hang in version 16.34. If you encounter that problem on an older build, install a current supported Excel release rather than installing that old version as a remedy.