Power Query Problems

Fix Power Pivot Query Editor Greyed Out in Microsoft Excel

Guest Writer Oct 10, 2026 870 views

Question details

The Query Editor option inside Power Pivot Table Properties is unavailable and cannot be clicked.

How to Fix Power Pivot Query Editor Greyed Out in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to access the Query Editor from Power Pivot Table Properties to edit or analyze datasets.
Observed behavior: The Query Editor option is completely greyed out across multiple datasets and file types.

Before you start

Ensure you have an active internet connection to download Microsoft Office updates and save any open workbooks before proceeding to avoid data loss.

Solution 1Recommended

Update Microsoft Office to the Latest Version

Use this solution to resolve missing features or bugs caused by an outdated Microsoft Office installation.

Often, features like the Power Pivot Query Editor become disabled or greyed out due to known bugs in older builds of Excel. Installing the latest updates can quickly patch these installation issues and restore functionality.

Open Excel Account Settings

Launch Microsoft Excel. Click on 'File' in the top-left corner of the ribbon, then select 'Account' from the bottom-left menu.

Check for Updates

Under the Product Information section, locate the 'Update Options' button next to Office Updates. Click it to open the drop-down menu.

Install Updates

Select 'Update Now'. Allow Microsoft Office to download and install any pending updates. Once completed, restart Excel and check your Power Pivot Table Properties.

Update Microsoft Office to the Latest Version

Update Complete: Keeping Office updated not only fixes add-in bugs but also ensures optimal security and performance for your data analysis tasks.

Solution 2

Run an Online Repair for Microsoft 365

If updating does not resolve the issue, repairing the Office installation can fix corrupted application files causing the feature to grey out.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Analysis

If Microsoft Excel frequently encounters add-in errors or greyed-out options, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet application for all your data processing needs without the hefty subscription fees.

1. Download the Installer: Visit the official WPS website and download the free WPS Office installer.
2. Install WPS Office: Run the downloaded file and follow the quick on-screen instructions to set up the software.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks to easily continue your data analysis tasks.

Highly compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Built-in robust data processing and PivotTable tools for advanced analysis.Free, lightweight, and fast to launch on any device.Seamless migration with a familiar user interface that requires no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Power Pivot tab missing completely from the Excel ribbon?

The Power Pivot add-in might be disabled. Go to File > Options > Add-ins, select 'COM Add-ins' from the Manage dropdown at the bottom, click 'Go', and check the box for 'Microsoft Power Pivot for Excel'.

Can I use Power Query Editor without opening Power Pivot?

Yes, you can launch the Power Query Editor directly from the Excel ribbon by navigating to the Data tab and selecting Get Data > Launch Power Query Editor.

Do all Microsoft 365 versions include Power Pivot?

No, Power Pivot is only available in certain Office versions such as Microsoft 365 Apps for enterprise, Office Professional Plus, and standalone Excel. Check your license version if the feature is entirely missing.

Excel & Data Problems