Office Settings & Configuration

How to Fix Excel for the Web Hidden Grid Columns Error

Emma Brown Sep 28, 2026 869 views

Question details

Users encounter a false error message in Excel for the Web indicating that all worksheet columns are hidden.

How to Fix the Excel for the Web Hidden Grid Columns Error

Product: Excel for the Web
Device & OS: not provided
Scenario: Opening and viewing a workbook in the web-based version of Microsoft Excel.
Observed behavior: The web app displays an error stating all columns are hidden and prevents viewing data, even though the columns are visible and the workbook functions normally in the desktop application.

Before you start

Ensure your internet connection is stable and verify that the file opens correctly for other users or in the desktop version to confirm the file itself is not corrupted.

Solution 1Recommended

Clear Browser Cache and Switch Browsers

Clearing the cache resolves local conflicts and outdated temporary files that cause browser compatibility issues with Excel for the Web.

Often, web applications like Excel for the Web store background data that can become corrupted over time. Clearing this cache forces the browser to load a fresh version of the application.

Access browser settings

Click the three-dot or hamburger menu in the top right corner of your current web browser and select 'Settings'.

Clear browsing data

Navigate to the 'Privacy and security' section, select 'Clear browsing data', and ensure that 'Cached images and files' is checked.

Restart the browser

Click 'Clear data', close the browser entirely, and relaunch it before logging back into Microsoft 365.

Try an alternative browser

If the error persists after clearing the cache, log into your Microsoft account using a different supported browser (such as Edge, Chrome, or Firefox) and open the workbook.

Quick Fix: Switching to an entirely different web browser is often the fastest way to confirm if the issue is cache-related.

Solution 2

Open the Workbook in the Excel Desktop App

Bypass web-specific glitches by launching the file directly in your installed desktop version of Excel.

Solution 3

Create a New Copy of the Workbook

Duplicating the file creates a fresh instance, which can resolve workbook-specific loading errors in the cloud environment.

Free Microsoft Office alternative

Switch to WPS Office for a Stable Spreadsheet Experience

Avoid browser-related errors and cache conflicts entirely by using WPS Office. It provides a powerful, offline desktop spreadsheet application that perfectly handles your Microsoft Excel workbooks without web-based glitches.

1. Download and Install: Visit the official WPS website, download the free suite, and complete the quick installation process on your computer.
2. Open the Spreadsheet Tool: Launch WPS Office and click on 'Spreadsheets' from the main dashboard.
3. Load Your Excel File: Click 'Open', navigate to your downloaded workbook, and start editing immediately without hidden column errors.

Seamless format compatibility with Microsoft Excel (.xlsx, .xls) filesFree and lightweight desktop application that works completely offlineFamiliar user interface ensuring zero learning curveEliminates reliance on web browsers, preventing cache and loading errors

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for the Web mistakenly say all my columns are hidden?

This usually happens due to corrupted browser cache data, an outdated browser version, or a temporary glitch in how the web application interprets the workbook's formatting data.

How can I tell if my Excel file is actually corrupted?

Try opening the file in the desktop version of Excel. If it opens normally and all grid columns are visible, the file is perfectly fine and the issue is restricted to the web browser environment.

Can this hidden columns error affect only one person?

Yes, because browser cache and settings are specific to your local machine, it is common for only a single user to experience the error while others can view the same file normally on their own devices.

Office App Problems