Pivot Table Issues

How to Display Source Data Without Calculations in Excel

Nimra Malik Oct 20, 2026 868 views

Question details

The user wants to display raw source fields such as telephone numbers, addresses, and cities without having them automatically summarized or calculated.

How to Display Source Data Without Calculations in Excel

Product: Excel
Device & OS: not provided
Scenario: Attempting to list and organize specific text or non-aggregate numerical data on a worksheet.
Observed behavior: When using a Pivot Table, the data is automatically summarized or calculated, which prevents the raw source data from displaying as an ordinary list.

Before you start

Ensure your raw data is organized in a clear, tabular format with each category of information placed in its own column with a distinct header.

Solution 1Recommended

Use a Standard Excel Table Instead of a Pivot Table

Converting your dataset into a standard Excel Table prevents unwanted automatic calculations while still offering dynamic range expansion, filtering, and sorting.

Pivot Tables are inherently designed to aggregate and calculate data. If you need to list raw source fields like phone numbers, addresses, or unaggregated values, a standard Excel Table is the correct tool to use.

Organize your data

Enter your data so that each field (e.g., telephone numbers, addresses) is in its own column with a clear text header at the top row.

Select the data range

Click and drag to highlight the entire range of cells containing your source data, making sure to include the headers.

Insert a Table

Navigate to the 'Insert' tab on the top ribbon and click on 'Table'.

Confirm table headers

In the pop-up dialog box, check the box that says 'My table has headers' and click 'OK'.

Use a Standard Excel Table Instead of a Pivot Table

Dynamic Expansion: The table will now expand automatically when you add new rows, keeping your raw data organized without applying any unwanted summaries.

Data Management Made Easy

Easily Manage and Display Raw Data with WPS Spreadsheet

WPS Spreadsheet provides powerful and intuitive table features that allow you to display, filter, and manage your source data without forcing unwanted calculations.

1. Open your dataset in WPS Spreadsheet: Launch WPS Office and open your workbook containing the raw data.
2. Select your data: Highlight all columns and rows containing your source information, including the headers.
3. Insert a standard Table: Go to the 'Insert' tab and select 'Table' to format the range as a dynamic table, preventing automatic summarization of your addresses or numbers.

Organize source data cleanly with standard tables without unwanted aggregations.Fully compatible with Microsoft Excel (.xlsx) file formats.Free, lightweight, and features a familiar user interface for seamless workflow.

microsoft office alternative - wps office

Frequently Asked Questions

Why does a Pivot Table always summarize or count my data?

Pivot Tables are built specifically for data aggregation. When you drag a field into the Values area, the application automatically applies a calculation like SUM or COUNT. To avoid this entirely for non-aggregate data, standard tables are recommended.

Can I disable calculations entirely in a Pivot Table?

You cannot completely turn off calculations for items placed in the Values area of a Pivot Table. You can place fields in the Rows area to display unique labels without calculation, but it is less efficient than a standard table for viewing pure raw data.

How do I remove the table format but keep the raw data?

Click anywhere inside your formatted table, navigate to the Table Design tab on the ribbon, and select 'Convert to Range'. This removes the table functionality while keeping your data and cell formatting perfectly intact.

Excel & Data Problems