Fix Excel File Name or Path Errors When Opening Workbooks
Question details
The user needs to open Excel workbooks that produce a file name or path error.

- Product
- Microsoft Excel
- Device & OS
- macOS; version not provided
- Scenario
- Opening workbooks, including files that previously worked on two computers.
- Observed behavior
- Excel reports a file name or path error for every workbook. Possible causes include an unavailable path, a file in use, or a duplicate workbook name.
Check your Excel version under Excel > About Microsoft Excel and your macOS version under the Apple menu > About This Mac. Note whether the workbooks are stored locally, on a network drive, or in cloud storage.
Update Excel for Mac
Use this first when every workbook produces the error; updating Excel resolved the reported issue.
Open Excel and select Help > Check for Updates. Install available Office updates through Microsoft AutoUpdate.
If you installed Excel from the Mac App Store, open the App Store, select Updates, and install any available Excel update.
Quit and reopen Excel, then select File > Open and try a workbook that previously showed the error.

Check the workbook location and file name
Try a short local path when the workbook is stored in a long folder path, on a network drive, or in cloud storage.
Release file locks and avoid duplicate workbook names
Use this when the workbook may be open elsewhere or another open workbook has the same name.
Open Excel Workbooks with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for an easy transition, although it does not repair Microsoft Excel itself.

Frequently Asked Questions
Why does Excel show a file name or path error for every workbook?
The cause may be an Excel installation issue rather than a single damaged file. Update Excel using Help > Check for Updates, then test a workbook from File > Open.
How can I tell whether the file path is causing the error?
In Finder, copy a workbook to a local folder such as Documents and give it a short name. Open that copy through Excel > File > Open. If it opens, check the original folder path and access permissions.
What should I do if the workbook is in use?
Close the workbook in Excel and quit other programs that may be using it. If another open workbook has the same name, close it or rename a local copy before trying again.
What information should I collect if updating Excel does not help?
Record the Excel version from Excel > About Microsoft Excel, the macOS version from the Apple menu > About This Mac, the file location, and whether the same error occurs on both computers. A screenshot of the error can also help with troubleshooting.




