Pivot Table - ignoring data filers on the Pivot Table Raw Data

Styromaker

New Member
Joined
Mar 11, 2018
Messages
1
Running Excel 2013 on Windows 10

Working on a s/s where I have a data filter on the raw data list

Pivot tables always worked on the raw data only ignoring any filter on the raw data?

Is there a way to switch off this so the pivot table ignores the filter on the raw data
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,758
Office Version
365
Platform
Windows, MacOS
I'm not seeing that. Whether I use a filtered Table or an old-school AutoFiltered range, a newly created Pivot Table ignores the filtering of the data and shows it all, until I apply filters in the Pivot Table.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,889
Messages
5,411,050
Members
403,337
Latest member
lgjohan

This Week's Hot Topics

Top