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
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,699
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.
 

Forum statistics

Threads
1,077,664
Messages
5,335,568
Members
399,025
Latest member
alce

Some videos you may like

This Week's Hot Topics

Top