Fix an Excel File That Cannot Open Because the Path Is Too Long
Question details
The user needs to open Excel workbooks that report a path-length error.

- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- Multiple people use workbooks stored in shared locations with long folder paths and file names.
- Observed behavior
- Some workbooks cannot be opened from their original locations but open after being emailed elsewhere. Enabling the Windows LongPathsEnabled registry setting did not resolve the error.
In File Explorer, check the workbook's full path, including the drive or network location, folders, file name, and extension. If others use the same files, coordinate any shared-folder changes with them before renaming or moving folders.
Shorten the Workbook's Folder Path
Use a shorter folder path to retain descriptive workbook names while reducing the total path length.
The total path includes the drive or network location, every folder name, the file name, and its extension. Office 2016 may still enforce path-length limits even when Windows long-path support is enabled.
In File Explorer, navigate to the affected workbook and select the address bar to inspect its folder path.
In File Explorer, rename one or more long parent folders, or move the workbook to a higher-level folder with a shorter path. Coordinate changes to shared locations with other users.
If the workbook still will not open, right-click it in File Explorer, select Rename, and shorten its name while keeping the file extension.
Double-click the workbook in its shorter location, or select File > Open in Excel and browse to it.

Try a Mapped Drive for a Shared Network Folder
Try a shorter drive-letter path when renaming shared folders or files is impractical.
Open and Edit Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing workbooks into WPS, although it does not change Excel's path-length limits.

Frequently Asked Questions
What counts toward an Excel file's path length?
The path includes the drive or network location, all parent folder names, the workbook name, and its extension. Select the address bar in File Explorer to inspect the folder portion.
Why didn't LongPathsEnabled fix the error?
Enabling Windows long-path support does not remove every application's limits. Office 2016 may still enforce its own path-length restrictions, so try opening the workbook from a shorter location.
Can I keep the workbook name and shorten the path instead?
Yes. In File Explorer, shorten parent folder names or move the workbook to a higher-level folder. Coordinate changes first if other people use the shared location.
Will mapping a network drive always fix the problem?
No. A mapped drive provides a shorter drive-letter path, but Excel may resolve the underlying network path or still encounter its own limit. Test the workbook through File Explorer or Excel's File > Open menu.
Why does the workbook open after I email it elsewhere?
The copy may have been saved in a location with a shorter path. Compare its new folder path with the original location in File Explorer.




