logo
search
File Cannot Open

How to Fix Excel File Cannot Be Found or Opened on Mac

Algirdas JasaitisAlgirdas Jasaitis Oct 9, 2026 868 views

Question details

The user is unable to open an Excel file on a Mac, receiving a "cannot be found" error, even though the file is clearly visible in a folder and can be previewed using Finder's Quick Look feature.

How to Open an Excel File That Cannot Be Found on Mac
Product
Microsoft Excel for Mac
Device & OS
Mac (macOS)
Scenario
Attempting to open an existing Excel workbook from Finder on a macOS device.
Observed behavior
Excel fails to open the file and reports that the file cannot be found, despite Finder Quick Look successfully previewing the document contents.
Before you start

Before proceeding, ensure that the file is not currently locked by another application and that you have sufficient Read & Write permissions for the folder where the file is stored.

Solution 1Recommended

Rename the File to Remove Unsupported Characters

Mac's Finder allows certain characters like a forward slash (/) in file names, but Microsoft Excel cannot process them, leading to a "cannot be found" error.

If your file can be previewed with Finder Quick Look but refuses to open in Excel, the most common culprit is an illegal character in the file name. Removing these symbols usually resolves the problem immediately.

1
Locate the file in Finder

Open Finder on your Mac and navigate to the directory where the problematic Excel file is saved.

2
Edit the file name

Click on the file once to select it, then press the Return key on your keyboard to highlight the file name for editing.

3
Remove unsupported characters

Delete any forward slashes (/), backslashes (\), or other special symbols. It is highly recommended to use only standard letters, numbers, dashes, or underscores.

4
Save and open

Press the Return key again to save the new name, then double-click the file to check if it now opens successfully in Microsoft Excel.

Rename the File to Remove Unsupported Characters
Quick Tip: Avoid using characters like <, >, ?, [, ], :, |, or * when naming Microsoft Office files on a Mac to ensure maximum compatibility.
Free Microsoft Office alternative

Open Your Spreadsheets Seamlessly with WPS Office for Mac

If Microsoft Excel on Mac is causing frustration with file name bugs or consistently failing to open documents, switch to WPS Office. It provides a lightweight, free, and highly compatible solution to view, edit, and manage your spreadsheets without strict formatting restrictions.

  1. 1. Download and Install WPS Office: Visit the official WPS Office website to download the Mac version. Follow the standard installation prompts to set it up on your macOS device.
  2. 2. Launch the Application: Open WPS Office from your Applications folder or Launchpad.
  3. 3. Open the Spreadsheet: Drag and drop the problematic Excel file directly into the WPS Office workspace, or use the 'Open' menu to locate and launch the file instantly.
100% compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Free, lightweight, and optimized to run smoothly on macOSFamiliar tabbed user interface ensuring a zero-learning-curve migrationRobust file recovery and compatibility features built directly in
microsoft office alternative - wps office

Frequently Asked Questions

Why does Finder preview my Excel file but Excel cannot open it?

Finder uses macOS Quick Look, which is capable of handling special characters (like forward slashes) in file names. Microsoft Excel, however, has stricter file naming rules inherited from its cross-platform architecture, causing it to fail to parse the file path if it contains unsupported symbols.

What characters should I avoid in Excel file names on Mac?

To prevent 'cannot be found' or access errors, avoid using forward slashes (/), backslashes (\), asterisks (*), question marks (?), quotation marks ("), brackets, and colons. Stick to alphanumeric characters, dashes, and underscores.

How do I fix file permission errors on my Mac?

Right-click the problematic file in Finder, select 'Get Info', and scroll down to the 'Sharing & Permissions' section. Ensure that your specific user account is listed with 'Read & Write' privileges. If necessary, click the padlock icon to authenticate and make changes.