Power Query Problems

How to Fix Launch Power Query Editor Not Working in Excel for the Web

Olivia Miller Sep 29, 2026 869 views

Question details

The user is unable to open the Power Query Editor in Excel for the web, resulting in an unresponsive interface.

How to Fix Launch Power Query Editor Not Working in Excel for the Web

Product: Excel for the Web
Device & OS: not provided
Scenario: Attempting to access data connections or modify queries using Excel online.
Observed behavior: Selecting 'Launch Power Query Editor' does nothing, and the 'Get Data' button subsequently becomes unavailable or greyed out.

Before you start

Ensure you are using a supported browser like Microsoft Edge or Google Chrome, and verify that your Microsoft 365 subscription plan supports full Power Query capabilities.

Solution 1Recommended

Allow Third-Party Cookies and Pop-ups

Browser restrictions like blocked pop-ups or third-party cookies often prevent the web-based Power Query Editor from launching.

Excel for the web relies on multiple Microsoft domains to authenticate and load advanced features like Power Query. Strict browser tracking protections can mistakenly block these processes.

Access Browser Settings

Open your browser's Privacy and Security settings (accessible via the three-dot menu in Edge or Chrome).

Modify Cookie Preferences

Navigate to the Cookies and Site Data section and allow third-party cookies.

Add Exceptions

Add 'office.com', 'officeapps.live.com', and 'login.microsoftonline.com' to the list of sites allowed to send pop-ups and use cookies.

Reload and Test

Refresh your Excel for the web tab and click Data > Get Data > Launch Power Query Editor to see if it works.

Check Extensions: If the issue persists, temporarily disable any ad-blockers or strict tracking protection extensions you have installed.

Solution 2

Clear Site Data and Use Private Mode

Corrupted session data can cause the Get Data button to freeze. Using a private window helps bypass cached errors.

Solution 3

Switch to Excel for Windows

If web browser limitations continue to block access, switching to the desktop application provides the most stable Power Query experience.

Free Microsoft Office alternative

Enjoy Stable Data Processing with WPS Office

If browser restrictions in Excel for the web are slowing down your workflow, consider switching to WPS Office. It provides a robust, desktop-based spreadsheet application that frees you from internet connection issues and browser-based feature blocks.

1. Download WPS Office: Visit the official WPS website and download the free desktop application.
2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your Excel files directly to manage your data without web limitations.

Lightweight desktop application with no browser-related pop-up or cookie restrictionsHighly compatible with Microsoft Excel (.xlsx, .xls) formatsRich set of built-in data processing and analysis toolsCompletely free to download with a familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Get Data button greyed out in Excel for the Web?

The Get Data button may become unavailable if your browser is blocking necessary scripts or pop-ups, if the file is opened in 'View Only' mode, or if your current Microsoft 365 plan does not support advanced Power Query features online.

Are all Power Query features available in Excel for the Web?

No. While Microsoft is continually updating the web version, Excel for the web only supports a subset of Power Query features. Complex transformations or specific data connectors may require you to open the file in the Excel desktop application.

How do I clear cached data for Office web apps?

You can clear cached data by going to your browser settings, navigating to the privacy or history section, and choosing to clear cookies and site data. You can specifically search for 'office.com' and 'live.com' to clear data only for those domains.

Excel & Data Problems