File Cannot Open

Fix Excel Search Bar Opening a Blank Read-Only Workbook

Partner Editor Sep 28, 2026 870 views

Question details

The user encounters an issue where clicking a file from the Excel search drop-down menu fails to load the file, opening a blank, read-only workbook named 'Doc' instead.

How to Fix Excel Search Bar Opening a Blank Read-Only Workbook

Product: Microsoft Excel (Microsoft 365 Apps for Enterprise)
Device & OS: not provided
Scenario: Searching for a spreadsheet using the built-in search bar in Excel and attempting to open it directly from the drop-down results.
Observed behavior: The target file does not open. Instead, Excel opens an empty, read-only workbook, interrupting normal file-search integration, particularly with SharePoint.

Before you start

Ensure you are connected to the internet if your files are stored on SharePoint or OneDrive, and verify that the file has not been moved or deleted by opening it through the standard File menu first.

Solution 1Recommended

Open Workbook from the Search Results Sidebar

Bypass the drop-down menu glitch by opening your files through the extended search pane on the side.

This is the most effective workaround for the search drop-down bug in Microsoft 365, as it utilizes a different file-loading path that correctly resolves the file location.

Search for your file

Type your file name in the Excel search bar at the top of the application window.

Select more search results

Instead of clicking the file directly in the initial drop-down list, click on 'More search results' at the bottom of the list.

Open from the sidebar

Locate your file in the search-results sidebar that opens on the right side of your screen and click its name to open the workbook normally.

Open Workbook from the Search Results Sidebar

Sidebar Integration: Opening files from the sidebar bypasses the specific Quick Search bug causing the blank 'Doc' read-only file.

Solution 2

Open the File Through the Standard File Menu

Use the traditional open menu to manually navigate to your file location, ensuring Excel opens the correct data.

Solution 3

Update Microsoft 365 and Verify File Path

Ensure you are on the latest Office version to patch known bugs, and verify the file path to rule out sync errors.

Free Microsoft Office alternative

Switch to WPS Office to Avoid File Searching Glitches

Tired of encountering blank or read-only errors when trying to quickly open your spreadsheets? WPS Office provides a highly compatible, seamless, and free alternative to Microsoft Office. Enjoy a lightweight application that effortlessly manages all your XLSX files without frustrating search integration bugs.

1. Download and Install: Download WPS Office for free from the official website and follow the quick installation prompts.
2. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' from the main dashboard.
3. Find and Open Your Files: Click 'Open' or use the integrated search box on the Home screen to easily find and open your documents without read-only errors.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight design ensures fast loading and smooth, bug-free file searching.Tabbed viewing makes it easy to switch between multiple workbooks efficiently.Familiar user interface requires no learning curve when migrating from MS Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel search bar open a blank file called Doc?

This is a known integration glitch in certain versions of Microsoft 365. When you select a file directly from the Quick Search drop-down, Excel occasionally fails to parse the file path (especially for SharePoint files), resulting in a blank, read-only workbook being generated instead.

How can I find the exact file path of an open Excel workbook?

You can quickly find the exact directory path of an active workbook by typing the formula '=CELL("filename")' into any blank cell and pressing Enter. This displays the full local or network path along with the active sheet name.

Does this search bar issue happen with local files or just SharePoint files?

While it can occasionally happen with local files, it is most frequently reported with files stored in SharePoint or OneDrive. This is usually due to temporary syncing errors or path resolution failures within the Microsoft 365 search drop-down menu.

Document & File Issues