Pivot Table Issues

How to Fix Excel PivotTable Missing When Adding Data to Data Model

Khadija Khan Oct 1, 2026 868 views

Question details

The user cannot see the PivotTable after adding data to the Data Model, even though the PivotTable Fields list is visible and a PivotChart is present.

How to Fix a Missing Excel PivotTable When Adding Data to the Data Model

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a PivotTable and adding data to the Data Model to utilize features like Distinct Count.
Observed behavior: A PivotChart is generated with the Field List accessible, but the actual PivotTable grid is completely missing from the worksheet.

Before you start

Ensure your dataset has clear, unique column headers with no empty columns before inserting a new PivotTable.

Solution 1Recommended

Recreate the Report Using the PivotTable Option

The most common reason for a missing PivotTable in this scenario is accidentally selecting 'PivotChart' during creation. Recreating the report correctly resolves the issue.

When you use the PivotChart insertion tool directly, Excel may sometimes generate only the chart and the background field list without placing the visible PivotTable grid on your sheet. Starting the process from the PivotTable button ensures both are created if needed.

Select your data range

Highlight the table or data range you want to analyze in your Excel worksheet.

Insert a PivotTable

Navigate to the 'Insert' tab on the Excel ribbon and specifically click on 'PivotTable' (do not click 'PivotChart').

Add to Data Model

In the Create PivotTable dialog box, ensure you check the box at the bottom that says 'Add this data to the Data Model'.

Complete the creation

Click 'OK'. This will successfully generate the missing PivotTable grid alongside your PivotTable Fields list.

Recreate the Report Using the PivotTable Option

Distinct Count Enabled: Checking 'Add this data to the Data Model' ensures that the 'Distinct Count' option will be available in your Value Field Settings.

Advanced Data Analysis

Create Powerful PivotTables Easily with WPS Office

WPS Spreadsheet offers robust PivotTable functionalities, allowing you to summarize and analyze data effortlessly without missing table errors. Enjoy a clean interface and seamless compatibility with Microsoft Excel files.

1. Open your data file: Launch WPS Spreadsheet and open the document containing your dataset.
2. Select the data: Highlight the range of cells you wish to include in your PivotTable analysis.
3. Insert the PivotTable: Go to the Insert tab on the top ribbon and select 'PivotTable'.
4. Configure the placement: Choose whether to place the PivotTable on a new worksheet or an existing one, then click OK to start building your report.

Fully compatible with Microsoft Excel (.xlsx) files and formatsIntuitive PivotTable creation and data modeling without missing gridsFree and lightweight alternative for powerful data analysisCross-platform support for Windows, Mac, and Linux environments

microsoft office alternative - wps office

Frequently Asked Questions

Why do I only see the PivotTable Fields list but no table?

You likely inserted a PivotChart instead of a PivotTable. When creating the report, ensure you click the 'PivotTable' button from the Insert tab instead of the 'PivotChart' option.

How do I get the Distinct Count option in my PivotTable?

To enable Distinct Count, you must check the 'Add this data to the Data Model' box in the initial Create PivotTable dialog box. Once the table is created, right-click your value field, choose Value Field Settings, and select 'Distinct Count' at the bottom of the summary options.

Can I add a PivotTable to an already existing PivotChart?

While it is possible to insert a separate PivotTable onto the same sheet, it is highly recommended to delete the standalone PivotChart and recreate the report by selecting 'PivotTable' from the Insert tab to keep the data sources perfectly aligned.

Excel & Data Problems