Pivot Table Issues

Fix PivotTable Report Filter Options Greyed Out in Excel

Rana Garcia Sep 30, 2026 869 views

Question details

The user is unable to select Show Report Filter Options or Show Report Filter Pages because the commands are greyed out in their Excel PivotTable.

How to Fix Greyed Out PivotTable Report Filter Options in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to generate separate report pages or use advanced filter options on an existing PivotTable.
Observed behavior: The Show Report Filter Options command is unavailable and appears greyed out in the PivotTable tools menu.

Before you start

Check your PivotTable Fields pane to see if there is an 'Active' and 'All' tab at the top, which indicates your PivotTable is connected to the Excel Data Model.

Solution 1Recommended

Create a Standard PivotTable Without the Data Model

The most direct way to restore the Report Filter Options is to recreate the PivotTable without adding it to the Excel Data Model.

When a PivotTable is connected to the Excel Data Model, it utilizes different underlying filtering capabilities (OLAP). This disables standard features like 'Show Report Filter Pages'. You must create a standard PivotTable to use these options.

Select your source data

Highlight the range of cells or the Excel Table that contains the data you want to analyze.

Insert a new PivotTable

Navigate to the Insert tab on the Excel ribbon and click on 'PivotTable'.

Uncheck the Data Model option

In the Create PivotTable dialog box, look at the very bottom and ensure the box for 'Add this data to the Data Model' is unchecked, then click OK.

Access Report Filter Options

Build your PivotTable by dragging a field into the Filters area. Go to the PivotTable Analyze tab, click the Options dropdown arrow in the PivotTable group, and 'Show Report Filter Pages' will now be available.

Create a Standard PivotTable Without the Data Model

Problem Resolved: By skipping the Data Model, your PivotTable functions as a standard report, restoring all traditional filtering tools.

Solution 2

Use Slicers for Data Model PivotTables

If you are required to keep your PivotTable connected to the Data Model for complex relationships, use Slicers as a robust alternative filtering method.

Create PivotTables Seamlessly in WPS Office

Easily Manage PivotTables and Filters with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive interface for creating PivotTables and managing complex data filters, allowing you to generate comprehensive reports without the confusion of restricted data models.

1. Open your data file: Launch WPS Spreadsheet and open the dataset you want to analyze.
2. Insert a PivotTable: Navigate to the Insert tab on the top ribbon and click on 'PivotTable'.
3. Select range and location: Confirm your data range, choose whether to place it on a new or existing worksheet, and click OK.
4. Configure filters: Drag your desired fields into the Filters area within the PivotTable Fields pane on the right.
5. Use Filter Options: Click the Options dropdown under the PivotTable Analyze tab to instantly access and use 'Show Report Filter Pages'.

Fully compatible with Microsoft Excel (.xlsx) formats and PivotTable structures.Intuitive drag-and-drop PivotTable builder with fully accessible filter options.Lightweight software that processes large datasets quickly and smoothly.Completely free to download and use for your daily data analysis needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why are standard PivotTable commands disabled when using the Data Model?

The Excel Data Model uses a different underlying engine (Power Pivot/OLAP) to process data, which is designed to handle multiple tables and complex relationships. Because it structures data differently, legacy commands like 'Show Report Filter Pages' or specific calculated fields are not natively supported by this engine.

How do I know if my PivotTable is connected to the Data Model?

You can check by looking at the PivotTable Fields pane. If your table name has a small cylinder icon next to it, or if you see 'Active' and 'All' tabs at the very top of the pane, your PivotTable is connected to the Data Model.

Can I disconnect an existing PivotTable from the Data Model?

No, once a PivotTable is created and linked to the Excel Data Model, it cannot be reverted to a standard PivotTable. You will need to insert a brand new PivotTable and ensure the 'Add this data to the Data Model' checkbox is left unchecked during creation.

Excel & Data Problems